Combo box search on dates

[shelds]

I would like a combo box on a form so it searches for records that a match a certain date, stored in checkdate field on my database. I'm wondering if it is possible to have a combox box that displays a calendar when clicked instead of a drop down which lists all of the dates in the field. The date selected on the calendar will then be searched rather than a manual entry in the combo box, it would then update the form with the records information. I know there is a calendar in the active x tools. Any advice or hints would be greatly appreciated.

 

[hwkranger]

it's possible if you make your own control. lol Otherwise i'm not sure you can achieve this.

Randall Vollen
National City Bank Corp.

 

[rjoubert]

If you were working in .NET 2005, you would have access to a nice calendar control that works just like that. However, I don't think Access has that kind of control. You would need to use the bulky calendar control in Access.