How can I limit a Combo Box list?

[JweldonH]

My issue probably has a simple answer.

I want to limit a populated combo box to items that are NOT in use in another table. I have a Table with a field that looks up values from another table via a combo box. As I select items from that combo box list, I would like for the list to automatically remove that selection from the combo box list so it wont be availble to select. (And have it add any item that I change or remove from the tabe) The list is quite long and having it populated with every item is cumbersome to go through each time.

Please let me know if I need to explain further.
Any help is appreciated.

James

[nico5038]

Best to make the rowsource to exclude these.
Goto the QBE editor and place both tables.
JOIN the tables by using drag and drop on the needed ID's.
Double-click the JOIN line and select option 2 or 3 to make the "main table" the one for display.
Now place besides the needed combofields the ID of the "not in table" table.
Give that ID the criteria:
Is Null
(There should be NO surrounding quotes ! )

Now place that query in the combo and check the result.

Nic;o)

[NeoPa]

You may need to do a requery too somewhere if your form affects the table that is being checked against.
Where you put this will depend on how you are using it and what updates are being made.