I have a access diary with individual records held under the bookingdate record.

I have the activex calender control on the form to.

The question is how do I get access to show the records in the form when I click a particular date on the calender control..

i.e click 30/1/2010 on the control and hay presto the records under that date appear.

You kind help would be appreciate and would stop me from becoming bald.