cascading combo help

[zambam]

hi,

i have created a combo box that is linked to a query. it shows the books that are in stock. here is the sql:

SELECT Books.[Book ID], Books.[Book Title], Books.[In Stock?]
FROM Books
WHERE (((Books.[In Stock?])=Yes));


i want to create another combobox, which will show the books not in stock.

so that when someone takes a book, it is removed from the first combobox and put in the second one.

and when they bring the book back, the second combo will display the books not in stock, which once selected, will get put back in the first combo.

pls help ive been trying to crack this for ages even though it is supposed to be soo simple

thanks!

 

[RuralGuy]

What is wrong with:
WHERE (((Books.[In Stock?])=No));

 

[zambam]

thanks for your reply

what im trying to say is that when i click the book title in the first combo box, it should transfer it to the second combo box to show that it is not in stock...

how would i do this?

 

[RuralGuy]

Just requery the 2nd ComboBox.