filtreing a combobox

[Puso]

i need help filtering the data in a combox
i have a combo box that chooses tour guides for bookings. what i want to do is that if a tour guide is selected then the tour guide's name must be taken off the list in the combobox on the form but not off the original table.
the user should not be able to book the guide more than once for that transaction.
is this possible? and how do i go about doing this?
any help or a point in the right direction will be appreciated

 

[Len Boorman]

Need a bit more info really but essentially

1) Create a list of Tour Guides
2) Add to this via a UNION ALL query Tour Guides already allocated
3) Select from this combined list Non Duplicates

This gives you a list of available guides which you can use as the source of the combo box.

Thing is you will probably need to factor on tour dates.

I normally write this type out to understand the logic and get it right and then set about the queries

Len

 

[Puso]

thanx for the help
i understand your reply
ive also found another way to do this by creating a textbox with an iif statement that if a guide is booked for that day assigns a -1 to the tour guide and i use this as my filter to remove it from the query