How for I produce combo boxes for Date(day,month,year),

[Delboy14]

Access 2002

I have a simple query (possibly the calm before the storm), I want to create 3 combo boxes which allow users to enter a date: Day, Month & Year. How do I get the boxes to offer the correct values; e.g. 28 days in Feb if not a leap year etc.

 

[JoeMiller]

Why not use a calendar control instead of drop downs? People are much more familiar with a calendar interface and I believe it would make it easier for them to work with, plus you don't have to do any coding.

HTH Joe Miller
joe.miller@flotech.net