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

listbox and drop down list query!!

P: 49
Hello All,

Just got a quick query,

I have an order form, if an item is selected from the ItemID drop down list. this would display within a listbox, and then another item could be ordered. I want to make a way so that the same item cannot be selected again from the drop down list only for this particular order .
So for the next order all the items would reappear and items could be ordered as normal.

Any ideas would be much appreciated.
Feb 5 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,341
I would use a Not In with a subquery to return the items for that order and then requery the list box each time a new item is added or removed from the order. This of course hinges on the fact that your tables are normalized.
Feb 5 '08 #2

Post your reply

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