Setting default for combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dialog form that allows the user to choose a Month and Year. I want
the default month to appear that's the month prior to the current month.
i.e. if it's October now, I want the default to be Sep.

The month and year in the dialog form are comb boxes.

Do I have to put some code in the open form procedure? If so, could you
tell me what that would be? I only get errors.

Thanks.
Meryl
 
In the open form event insert the following

Me!field_name = DateAdd("m", -1, Date)

then format your field_name to mmm
 
Thank you! That worked perfectly. Meryl

Allan Murphy said:
In the open form event insert the following

Me!field_name = DateAdd("m", -1, Date)

then format your field_name to mmm
Click to expand...
 
Back
Top