Default to current month in Access form field

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

Guest

Hi

i have a form in which i need to have the field default to
the current month and year. I have a combo box with a drop
down list of months and years. How do i set the properties
to default at the current month. It has to show
as "January" and "2003". Thanks
 
Private Sub Form_Load()
Me.cbMonth = Format(Date, "mmmm")
Me.cbYear = Format(Date, "yyyy")
End Sub
 
Back
Top