ComboBox date selection

[DJBummy]

Hello All
I have a form that I use to select a month and year for a query. I am using two seperate combo boxes. Month and Year.
What I would like to do is have the current month and year display in the combo boxes whenever the form is opened.
Tried setting the default value to
Format(Date(),"mmmm") and Format(Date(),"yyyy") but to no avail.
By the way the combo boxes are based on two seperate tables January thru December and the year table is 1990 thru 2030. Is this a practical way of doing the combo boxes.
Thank you in advance
DJ

 

[DJBummy]

Well sometimes the solution is so simple that its comical.
Simply changed to Format(Date(),"m") instead of Format(Date(),"mmmm")
Is my face red!

It was because of the bound column.

[This message has been edited by DJBummy (edited 12-04-2001).]