Load variable with multiple values from listbox and use in query.

[Apollo6]

MSAccess 2003

I have a form with two listboxes. The user moves items from listbox1 to listbox2(target). I want to move all the items from the target listbox into a variable and use that variable as criteria in a select query. The variable would need to have OR between the values due to the possibility of multiple matches on that field. Is this possible or is there a better way to go about this?

Thanks for any assistance.

 

[PHV]

Have a look at the ItemsSelected collection of the ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Apollo6]

Thanks for the lead, looking into it.