Using Calendar Control to set query criteria

  • Thread starter Thread starter ll
  • Start date Start date
L

ll

I am using the calendar control in Access to set the start and end date
for criteria in a query. I have completed the form with the calendar
control (two combo boxes, each of which trigger the calendar control,
which then populates the combo box).
I need for the value in the combo boxes to become the "from" and "to"
of the date range criteria in my query. How would the values from the
boxes be set to equal the query criteria?

Thanks for your help in this,
Louis
 
In the date field criteria place something like this:
BETWEEN Forms.FormName.nameofbeginningdatecombo AND Forms.FormName.
nameofendingdatecombo
The form must stay open until the query runs.
 
Back
Top