2+ Criterion & listBox

[CptTom]

Using a Listbox, how do I allow the user to select multiple criterion. Put simply, Select, CA, NM, ID & ME.

If the user selects "Multiple" then I want the program to basically continue allowing the additions until the user Presses a "Stop" button and the selections be shown below or to the side.

I know how to write the basic code of adding Filter criteria, I just want to know how to do the looping part. Once I have that down, then I could extend it to multiple states & multiple products.

strFilter = strSelection
Do Until ...
strFilter = strFilter & " OR " & strFilter
Loop

Larry

 

[Mossoft]

Set the MultiSelect property of the list box to True. Once they have finished selecting you can loop round each element of the lstBox.Selected() array of the list box.

HTH

M

 

[CptTom]

Super! Now, is there a way to move the selections to a separate list box, so that the user can 'unselect'?

Larry