Two multi select list boxes as rpt filter

[DaveMac]

Q? Has anyone ever setup two multi select list boxes for a selection form to a report qry? I have combo boxes right now but would like to have two list boxes. I have seen all the posts on setting up one but not two. Here’s what I have.

‘the two fields I am targeting
‘they are in my issues tbl
[Type],[Status]

‘the frm I am using
Frm_select_dialog_issue_rpt

‘the rpt
Rpt_filtered_issues

I don’t even know where to begin on the code. I know the basics on the buttons and list boxes I just don’t understand how to build the str and pass it to the qry



Thanks for any help

 

[dhookom]

There are a couple FAQs on this. Check out faq703-3936.

Duane
MS Access MVP

 

[MakeItSo]

I have also written a FAQ for it:

http://www.tek-tips.com/faqs.cfm?spid=701&sfid=4432

Regards,
MakeItSo