Select OnActiveSheet

[#1]

Hi hoping someone can help.

I have a selction box on my report that uses =MonthStart(MonthStart(DateCreated)) i would like it so when this sheet is selected it automaticly selcts the Max date.

On the Sheet Properties i have slected ONActiveSheet Selct Field. The field =DateCreated and the Search String =Max(MonthStart(DateCreated)) but clicking on off and the sheet doesnt make it select the latest month.

Any ideas?

Many Thanks

Gez

[#2 · Accepted solution]

hi,

see the attached example for more help.

Good luck!

Rainer