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