Combo box multiple selection solution

[Alo2aaa]

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

[nico5038]

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)

[gank456]

@Alo2aaa
Could you please provide the code module??
and using which programming language have u done this??

[missinglinq]

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)>