By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

How can I limit a Combo Box list?

P: 1
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
Dec 29 '06 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Dec 29 '06 #2

NeoPa
Expert Mod 15k+
P: 31,271
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.
Dec 30 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.