Date Criteria/Form

  • Thread starter Thread starter C. Houk
  • Start date Start date
C

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
 
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 & "#"
 
Back
Top