G
Guest
Is it possible to select multiple values from either a list or combo box?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
This is a property of list boxes but not combo boxes.
G
Guest
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
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