Want a calendar pop-up for date ranges

[watrout]

I have a access db in which I want to get a calendar to pop-up rather than the user having to manually enter a date range for the ask criteria of several queries. What's the best/easiest way to go about this?

 

[michaelbr55]

In access their is no easy way. But you could try this.

Create a new form, click on the Control Toolbox toolbar select More Controls, select Calendar Control 8.0, paint the calendar control onto your new form and add a control button to the form.

Set the control button's actions to 'Form Operation', 'Close Form'

Set the following properties for the form
Scroll Bars = Neither
Record Selectors = No
Navigation Button = No
Record Source = the table where your records are kept
On Enter Event = macro1 (action = open form), (form name = 'your calender form')

Set the following proterties for the Calendar COntrol
Control Source = the field in the table that will hold the date
Modal = Yes


I think that's it, if not you'll be the first to know!

Mike