Default Dates in combo boxes

[splint1906]

I have a form where the user choose the Starting MMM-YYYY and Ending MMM-YYYY. I'd like to set the default value for the Starting Period and the Ending Period to Jan-Present Year and Dec-Present Year.

I've tried to use the following code on the OnOpen event procedure of the form but I think my syntax is wrong:

Me.Starting_Period.Defaultvalue = "Jan-" &Year(Now())

 

[M8KWR]

change your code to

Me.Starting_Period = "Jan-" &Year(Now())

but if you want it as the default value set this in the properties on the control, not when you are trying to open up the form.

 

[splint1906]

thanks. That worked.