Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
see the attached example for more help.
Good luck!
Rainer