check out http://www.glump.net/content/accessdatepicker/
i got it to work really well with one database, but couldn't get it to work
with a second must have read the directions differently
Go to http://www.byerley.net/BdcDownSup.htm scroll down to AccessCalDemo.Zip. It contains an
Access2K database with form that demonstrates various methods to do what you want either from double
Clicking in a textbox or pressing a command button. Plenty of comments in the code to direct you.
One of the best I've used is by Drew Wutka at http://www.wolfwares.com. And,
he's got an even more impressive one in the works. It is not a Control, but
completely done with Access, so you don't have to distribute any other DLLs,
etc., with your application.