Calender funtion in Query

[CharlesCount via AccessMonster.com]

Thanks to Adems and Daniel I added the calender function to the forms.
Now I would like to know can the calender be made to pop up when I run a
report and the information is generated by a query that is set up to prompt
for the dates? Start and End or between dates?

Thanks

Charles

 

[Ron2006]

You will need to set up a form that has a from and to date box (and
your calendar buttons [one for each date]) and a button to run the
report and have the report reference that form as the source for the
dates it needs for the criteria.

You could also use the double-click event for each of the dates to
have the calendar pop up.

In the code for the button, don't execute the report if either of the
dates is empty(null) or the to date is less than the from date.

Ron