Date Criteria/Form

[C. Houk]

Currently I have a report that links to a Query. The
query has a Criteria in the "Date" column for [Date of
Test]. When the report is run a box opens in which the
test date is typed in and the appropriate information is
displayed in the report.
What I want is a little more user friendly method. I am
looking for a way to have the Calander Control open when
the report is run and the user simply clicking on the
appropriate date to satisfy the criteria of [Date of
Test]. I do not want a Date Range, I want a specific date
to come up. Is there any way to do this by using a form?
If so, how do I get the form to provide the criteria?
Thank you for your time.

C.R. Houk
charles.houk2<remove>@charleston.af.mil

 

[Alan Fisher]

If you add a claendar to the form you can create a command
button with the following code in the On Click criteria:

DoCmd.OpenReport "ReportName", , , "[DateStart]=" & "#" &
Calendar.Object.Value & "#"