Select multiple items in a combobox


G

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
 
Ad

Advertisements

G

Guest

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

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top