ActiveX Calendar wont allow click if no records show

G

Guest

Hi everyone
I'm using two Calendar Controls (v10.0) to allow users to select records
between two dates to display on the form. If the date filter returns no
records, clicking on either calendar is prevented, ie. you can't select two
different dates to change filter options. I have to click on 'Show All
Records' and then, once some records are displayed, I may then select some
different dates to filter.
The form's control source is a table (not a query) as I had problems with it
wanting to display a new record (where one or two fields have default values)
when I used a query. If I prevented the new record from showing I then
wasn't able to click on the calendars.
Anyhow, do you know of a work-round that might allow the calendars to be
clickable when no records are currently displayed?
Many thanks,

Lee
 

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