Using all listbox vaules as query criteria

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
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
 
Back
Top