Select multiple items in a combobox

[Guest]

I would like to know what is the code to select multiple items in a combox.

I mean, if combo box has value a,b,c,d,e,f and I selected by "Cltr" a,c,d
and store thses values in the table or query of the Record source.

any help, really appreciate.

Thank you

 

[Guest]

A combo box is not able to do this. What you want is a multi select list box.

 

[Guest]

A combo box can only have one value. A list box, however, can permit
multiple selections if the MultiSelect property is set to Simple or Extended,
rather than None. See Help on the MultiSelect property.

To store these values requires code that loops through the selected items
and runs an Insert query. An alternate way have handling inserting records
is to bind a continuous form to the table of interest, and use multiple
records, each selecting a single value from the combo box.

Hope that helps.
Sprinks