Does anyone know of a good example

[Bensta]

Does anyone know of a good example where they use calendar control in access to open a report. It filters the data based on the date range entered in the calendar control then it passes the string to a report, which the lasted display the info.
Thank you in advance
Bensta

 

[markgrizzle]

I've used calendar controls on forms to get date ranges, but I had to use 2 controls (one each for start and end dates), each on their own tab. I'm not sure the calendar control that ships with Access lets you select a range.

When the user selected the end date, the calendar's click event grabbed the first and last date, used it for the date range, and modified the report sql on the fly.

 

[Bensta]

Could you please show me an example? I also want to grab a name field from a combo box and then select a date range from the calendar control.
Thank you so much