Reading Listbox Selections (multiselect)

[Smoores]

I have a multiselect list box made. The user is to select as many of the listbox options (they are only order numbers) as necessary. The ones selected refer to the records that get printed; the ones unselected are ignored. Can anyone help me with the code that would identify which numbers (options) are selected.

Thanks for any help!
Smoores

 

[jebry]

Hi Smoores!

You can loop through the selections like this:

Dim varRow As Variant

For Each varRow In Me!YourListBox.ItemsSelected
Do your stuff here you can access any column in the list
box using Me!YourListBox.Column(0, varRow). 0 gets you
the first column 1 the second etc.
Next varRow

hth
Jeff Bridgham
bridgham@purdue.edu