Want to use the selected items from list box in a Attached query of a report

[chinkyk]

I have a form that has a list box(multiple values selected) and multiple report names(when clicked on the button, it will run the report) on the form. I have selected multiple items from the list box. Now I want to use the listbox selected items, in the reports query. All the reports have a query attached to it. So I want to use the selected items from the list box in the query, in the In clause of the query. Please help.

[PEB]

Hi,

It seems that it's possible only using VB statements... For your query and for retrieving the selected items...

Or the other way maybe using VB code for retrieving your selected data in the list and save it in a temporary table which is used in your query!

Which manner is more convenient for U? And in the 2 cases it's long to describe!

However IF U want to continue pls tell me the name of your form and the list name in the form

:)