I have a query that retrieves a bunch of data from a table, including a date
field. I have a form that displays the query results. On the form I have two
calendar controls. The user selects the start date from one calendar and then
the end date from the other calendar. In the query I have set the criteria in
the date field to select only records that are between the two calendar dates
(Between Forms![My Sales].calStart.Value And Forms![My Sales].calEnd.Value).

If I hard code two dates for the date field criteria and then open the form,
I can click on the calendar controls and select a date (of course that
doesn't do anything). When I change the criteria to select the dates from the
calendar controls, I have problems. When I open the form the calendar
controls are locked. I can't select a date on the calendar - clicking on the
calendar does nothing. I don't know why this is happening. How do I fix this
problem?

I'm using Access 2000 with Calendar Control 10.0

Thanks in advance.

Evan