Show records by date

[Guest]

I am trying to design a form which shows only those bookings on a certain
date. My fields would be [checkindate] [checkoutdate] and usual booking
information. At the moment I have it designed so that when the form opens up
it asks you the checkin date and checkout date and displays those bookings.
I'm wondering if I could have a control on the form to select any date and
for my form to show the bookings on that date as a list. Any ideas?

 

[Douglas J. Steele]

If it's prompting you now, then presumably you've created a query with
criteria for those two fields.

To have it refer to controls on a form instead, replace the existing
criteria with references such as Forms!NameOfForm!NameOfControl.

(Note: the form must be open for the query to work. If it isn't, Access will
not open it for you. Instead, you'll get prompted, like now)