This is a Non-ActiveX and Non-API Access 2002-2003 version of a calendar looking form. It's setup to easily be integrated into any existing mdb (just import either the "CalendarPopUp" or "SubCalendar" form.) All code is contained within the form and there are no modules, API Calls, or need to register any *.ocx file.
The CalendarPopUp is called by a date field button or other event.
The subCalendar has 1 function (bottom function) called: FireOffDateValue where you can add your own code to copy the date value from the subform to your main form or requery a list box based upon it's value.
I utilize the .Caption of the button to grab the day value and prevent the need to use any API calls.
(this is the same as the 2010 version but in a 2003 format)