Report based on 2 multi-select listboxes

[pippo]

Hello,
I have a form with various multiselect listbox
I want to open a report based on the criteria selected in multiple multiselect listbox
I have been able to do it with one multiselect listbox but not 2 or 3
I assume f I can do 2 I can figure out 3

the multiselect listbox are lst_Rep and lst_ClientType
the report is rpt_ActivityReport
Thank you!!

 

[sneuberg]

Typically a querydef is generated such that a WHERE clause ends up looks something like

WHERE SomeId IN (2,3,9)

I'd just repeat the same process for the other listbox and put them together at the end so they'd look like

WHERE SomeID IN (2,3,6) And SomeOtherField IN (4,5,7)

or

WHERE SomeID IN (2,3,6) Or SomeOtherField IN (4,5,7)

depending on what you want.