Form not filtering on multiple listboxes

[PinkLady50]

Hi,
I am a basic Access user and I am trying to build a database for Senior Management! I am little out of my league and could use some help.
I have 3 things that are all tied together.
I have 2 Listboxes in my form header. I was able to get the first listbox to work correctly. It allows me to make multiple selections and brings up a report. When I copy the code to create the second listbox the first one stops working and the second once is not selecting multiple items. In the end I will have a ListBox for the following fields - Manager, COD, Staff, Fiscal Year, Quarter, Category and Problem that will be mulitselect boxes. Once I can get two to work I can replicate the other listboxes.

I think this has to do with clearing the previous values but I am not sure how to do that.

The second problem is that I want the data selected in the listboxes to be viewable on the datasheet. Right now the Preview button takes you to a report. I will create a button for the report but I can 't figure out how to display the records. I have tried taking out the report language and playing around with several form views but can't figure out what I am doing wrong.

I have attached my database so you can view the code and form.



Any help would be much appreciated.
PinkLady50

[pbaldy]

The code for the first got disassociated with the button. I'd guess you renamed the button. Code already created will not follow that.

The Multi Select property for the second is set to None.

[PinkLady50]

Paul
Thanks for your quick response. The changes you suggested worked great!! How to I get my filters to display on a datasheet and not a report. I took the report code out but that didn't work. The table I want to reference is Problem_record.

[pbaldy]

I'm not clear on what you're after. If you had a subform you could set its filter, or recordsource.