Multi-select list as criteria

[WJReid]

Hi All,

I want to use a multi-select list box on a form as my criteria for running a query. The query is based on a Customers table and I want to be able to choose more than one customer for the query, running the query from a form. Can anyone help me with this please?

Thanks in advance for any help.

Regards,

Bill

 

[Rick M]

http://users.bigpond.net.au/abrowne1/ser-03.html

See if this will help!

 

[dtaylor]

Hi There,

First you need to capture to the listbox selection and pass to a variable.

something like this

AM = variable for selected listbox item(s)

for single selection:

AM = Me.lstAM.ItemData(Me.lstAM.ItemsSelected(0))

and then parse the variable into your sql statement.

For multiple selection:

For i = 1 To lstAM.ListCount

AM = lstAM.ItemData(i - 1)

'code for sql statement with variable parsed in

Next i


Hope this helps!

Dan