Using all listbox vaules as query criteria

M

Mark

Is there a way to use all the values in a list box in a
form as criteria in one field to filter parameter query
results? In other words, opening a parameter query using
the ALL the values in a list box as criteria for one field
to include the those recordsets.
 
J

John de Beer

Is there a way to use all the values in a list box in a
form as criteria in one field to filter parameter query
results? In other words, opening a parameter query using
the ALL the values in a list box as criteria for one field
to include the those recordsets.
Click to expand...

II have a app where I drop 1, more or all of a multi-select list box
into a table with append, and then use that table in a query with
another table to get what I want. It was a lot simplier that trying
to stick all of the values in a sql statement.

jdb
 
Top