list box should select values automatically

[#1]

hi All,

I have 2 list boxes.

1. Month

2. Week

When I select any Month, max week of that month ( 4 weeks get available automatically ) should get selected automatically.

I don't want any other action to do this, like cliking on button or etc.

I want when I click on month list box week list box should select max week of same month..

thanks in advanced

[sunny_talwar]

Use field event trigger for Month field

Field

Week

Search String

=Max(Week)

[prma7799]

Please try like this..