Search Query Using A Form

[Hysteria86]

Hi, I'm trying to run a query through a form, that takes several parameters and then checks to see if any rooms are booked at a certain time and date, that satisfy these parameters.

On the form there is :
Room - combo box
Time - text box
Date - text box
Computers - check box
Data projectos - check box
OHPs - check box
Desks - check box


I have this so far with the query. Can someone point me in the right direction on how to complete this successfully?

 

[Jon K]

I have this so far with the query. Can someone point me in the right direction on how to complete this successfully?

It would be easier to demonstrate with an example. See the database attached.

In the database, the subform is based on a simple select query (not a Totals Query as shown in your image.) The Allow Edits, Allow Deletions and Allow Additions properties of the subform have all been set to "No", so that the check boxes on the subform will not be inadvertently clicked and changed.

The Triple State properties of the check boxes on the main form have all been set to "Yes", so that the check boxes can be Null (greyed), Checked or Unchecked.


Note the joining of the three tables in the query. (Since the Room and the Equipment tables are in a one-to-one relationship, they can, in fact, be put in one single table.)

For an explanation of the criteria structure used in the query, you can see this thread in the Sample Databases forum:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

.