Enter a date in a drop down box

[Guest]

I'm working in Access 2002. I am building a form that requires the input of
an activity date - the date can be something other than the current date.
I'd like to set this up so when the user clicks on the arrow for the drop
down box, a calendar pops up and he/she can select the date to populate the
box. Does anyone know if this can be done? Thanks!

 

[Guest]

It can be done. You will need to get a good calendar control to use.

I am curious as to why you are using a combo box (drop down) to enter a
date. Combo Boxes are usually used when you want to select from a list of
options.

Also, from a data entry perspective, it is much faster to enter a date than
it is to open a calendar control and select a date. You do, of course, have
to validate the date after it is entered if you use a text box. I would
suggest you rethink your approach.