Double booking

[hayden]

I am having great trouble with this
I have created a compare query which has tells me whether there is a clash or not

but what i really need is a way in my form once i have selected the date only the available products for that day are displayed (i.e. booked out products not shown

products are booked out per day and time is not needed

 

[pbaldy]

Generally speaking, I'd probably have a query that returned the products that are booked for that day, then a second query that joined that query against the table of all products to return the available products (check out the unmatched query wizard).

 

[Brianwarnock]

But this has been answered for you before, you have been pointed at other threads and have implied that the problem is resolved, I'm certian that I cannot help again as the use of cascading combos shown for your first thread should have resolved your problems.

Brian

 

[hayden]

it solved the solution when it was basic, and still does but i would rather it be applied to the combo box which doesnt work

 

[vbaInet]

You say it "solved the solution" but aren't satisfied with the level at which the "solution was solved". Hmm... I would have thought a "solved solution" meant that there wasn't a "problematic problem".

From the sound of things you should use a Calendar control which, when clicked, will cause the record source of the combo box to show the available products based on the selected day. All you do is reference the value of the calendar control in the query. Then base the row source of your combo box on that query.

Use a collection of the idea presented by pbaldy, the solution from Brianwarnock and the following links to build the query:

http://www.techonthenet.com/sql/exists.php
http://www.access-programmers.co.uk/forums/showthread.php?t=103312&highlight=query+form

You decide your approach.

In spite of that, it seems a bit pointless performing the filtering on just the combo box and as a result I think there could be more control values you would like filtered based on the date. If that's the case then use a subform.