Get ListBox Multiple Selections into Query Criteria

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top