Your calendar named MyCalendar is on a form we will call PFrmMyCalendar. Add
a textbox named MyDate to the form and set its visible property to false.
Put the following code in the calendar's AfterUpdate event:
Me!MyDate = Me!MyCalendar.Value
Put the following expression in the criteria of the date field in your
query:
Forms!PFrmMyCalendar!MyDate
You now need to put this all together in however you have your system set up
so that you open the calendar form, select the date then run the query.

--
                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com