[color="blue"]Hello fellow Access developers! This Access 2000 database contains a form and a module. Whenever I collect dates, I assign the double-click event of the date to open this form -- it uses the calendar control and has buttons for quickly changing the date by week, month, year, etc.

Optionally, you can also enter a time. When you click OK, whatever you picked goes into the control you popped the form up from. It is very handy! Make sure you have a refernce to the ActiveX library. The one I used is specified at the top of the module code behind the PickDate form.

Hope this is beneficial to you. As always, I appreciate any comments you may have.