Using Calendar Control to set query criteria

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
 
J

jahoobob via AccessMonster.com

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

Top