Get ListBox Multiple Selections into Query Criteria

[Guest]

Thanks for taking the time to read my question.

I have a list box with product names and numbers in it. The bound column is
the one with the product numbers, and the list box shows the product names.

I have a query that runs a report. I want the user to be able to select
multiple products and then report on only those products.

So far I've made a global variable, and then assign a Function the value of
the global variable, and then set the criteria of my query to the Function.
This doesn't work because the global variable has to be a string so it can
look like this:

1 Or 2

This doesn't work in my query because the field is a numeric field.

What do I need to do to get the values selected in the list box to filter
the results in my query.

If the user wants all products, they select nothing in the list box.

Thanks for your help.

Brad

 

[Allen Browne]

See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

The query cannot read the ItemsSelected in the list box directly, but the
article explains how to build the WhereCondition string for OpenReport.