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

Combo box multiple selection solution

P: 1
Dear all

i have two linked combo boxes (master/child) ,the user wants to have multiple selection from both combo boxes , can u tell me how can i store them in a way that i can have a unique id for the selected items from the first combo box and also to the items selected from the second combo box? because i want to retrieve them in a search page

ex:

Combo box1:"Fruits","drinks","vegetables".
Combo box 2:"apple","banana","mango". when user selects fruit
:"water","milk".when user selects drinks
:"lettuce","cucumber" ... when user selects vegetables

users can select fruit and drinks from the first combo and produce them in alist
and they cando the same with the second combo box to produce them in the same list or in new list ......... Please help it's urgent

if u want any details please ask
Oct 1 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
Dear all

i have two linked combo boxes (master/child) ,the user wants to have multiple selection from both combo boxes , can u tell me how can i store them in a way that i can have a unique id for the selected items from the first combo box and also to the items selected from the second combo box? because i want to retrieve them in a search page

ex:

Combo box1:"Fruits","drinks","vegetables".
Combo box 2:"apple","banana","mango". when user selects fruit
:"water","milk".when user selects drinks
:"lettuce","cucumber" ... when user selects vegetables

users can select fruit and drinks from the first combo and produce them in alist
and they cando the same with the second combo box to produce them in the same list or in new list ......... Please help it's urgent

if u want any details please ask
A combobox can't be used for multiple selections like a listbox.
You would need code to "remember" the selections and also a way to deselect erroneous selections... :-(

Personally I would offer two subforms, one for each combo.
These subforms are bound to a table1 with the "Category" and a YesNo field and the table2 would hold the products and also have a YesNo field.
Now the user can click the YesNo fields for selection and you can show a third subform at the bottom based on the searchpage query/table. This table can be JOINed with the table1 and table2 and when you add for the YesNo fields the criteria "True" (without quotes!), then the user will directly see the effect of the selections in the upper two subforms.

Idea ?

Nic;o)
Oct 6 '07 #2

P: 2
@Alo2aaa
Could you please provide the code module??
and using which programming language have u done this??
Mar 26 '10 #3

missinglinq
Expert 2.5K+
P: 3,532
A combobox can't be used for multiple selections like a listbox.
Actually, this statement is only true thru version 2003! Access 2007 added the multi-select capability to Comboboxes.

Welcome to Bytes, gank456!

Linq ;0)>
Mar 26 '10 #4

Post your reply

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