is it possible to select multiple values from either a combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to select multiple values from either a list or combo box?
 
A combo box may only have one value selected. A list box can have multiple
selections if its MultiSelect property is set to Simple or Extended. You can
then work with the selections using the list box' ItemsSelected property.
For example, to display the list in an adjoining textbox, you could use the
following code (adapted from "Access 97 Developer's Handbook", by Litwin,
Getz, & Gilbert):

With Me![YourListbox]
For Each varItem in .ItemsSelected
strList = strList & .Column(0,varItem) & vbCrLf
Next varItem
Me![YourTextBox] = strList
End With

Hope that helps.
Sprinks
 
You must log in or register to reply here.

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

selecting multiple values on list box 2
Combo Box 2
Multi Value Combo Boxes 4
Unable to select a value from combo box 3
Combo box with a check list option? Is it possible? 5
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
filter on combo box possible? 1
can't select from combo box 4

Back
Top