Using Listbox selection values in query???

message from WOLFE on 22 May 2004
I am trying to use a list box to select what values should be used in a
query. The list box contains about 20 items, and is set so the user can
select multiple items. After selecting the items they wish to view, I would
like to run a query that will only return records with the selected item on
them. Is this possible? I have tried to store the selected values in an
array, and pass them to an IN clause, but that does not work. I thought
about using VB code to return the records to a recordset, but do not know
how to pass this to a report. Please help.

WOLFE
 

Archived message: Using Listbox selection values in query??? (MS Access)