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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access Control on subform / combo box requesting parameter 0
Default Query Criteria 1
Parameter Value error in a Subform 0
Disappearing Combo Box Value 2
CRITERIA 2
Parameter query problem 1
Excel Need Countifs Formula Help 0

Back
Top