Default Selection in the Multibox

[#1]

I have Year and Month in the multi Box. In the year i have 2009 and In the month li have Jan,Feb.Mar,Apr and May.

Now every time if the user open the dashboard, the selection in the Multibox should be the current month i.e., May (if i open today).

If any one opens in the next month,selection of the month would June.

Please help how to get the solutiion for this. Or if this is not possible at least any of the month selection will do for me.

Thanks,

Ram.

[#2 · Accepted solution]

Hi Ram,

Hope the attached file help you to select the default values.

Thanks,

Raghu.

[#3]

Thanks Raghu..It's workling for me.

[#4]

Hi There,

I have a field called "DayStarted" on pressing a button or changing to another Tab i would like the highest value to be returned, Ive looked at the above document but having problems implementing it.

The Macro has been changed to

Sub


 selectLatestDate







"DayStarted"



). Select ActiveDocument.Evaluate("max(ALL DayStarted)")
End Sub

On pressing the button the selections for the Date field don't appear to change. Any advice would be greatly appreciated.

Kind Regards

Gerard