Query criteria retrieved from a Form's listbox

[blacksaibot]

Right now on my form I have a comobox options within.
The query takes the selection from the form combobox like so:

[forms]![formname]![comboboxname]

It successfuly retrieves what the user selects, but how can I do the same thing but with a listbox that has a multiselect??

Would I have to right a loop that goes through each selected item and make a string with concatenations that will be part of my query?

Not sure about VBA syntax either. Is it the same as VB.NET?

[Guus2005]

First, VBA and VB.Net are totally different. You can't compare them.

For the listbox with multiselect you need to create a string of items separated by comma's. The string might look like this: "1,2,3,4,5,6"
Your query might then look like this:

select * from tablename where id in (1,2,3,4,5,6)

HTH