Recent content by pepperlc

so toggle are the user selected ones? This seems like a simpler way to do it. Do I use any of the code the others suggested? thanks pepper

Thanks for the code and demo. Sos: Does this work with a check box? And I'm guessing it just toggles everything one way or another through the entire list. Is that right? I would put this function in the checkbox click event? ChrisO's code: I'm concerned that the (all) and (none) will be...

Not even sure where to look for this. I have a multi-select listbox that is used to filter a report. The listbox works great but I wanted to add a select all or deselect all feature to the window. Can someone tell me how to do it or were to look for information about it? thanks pepper

Thank you so much. It took me a few minutes to see what you were referring to. Once I made the switch it worked great.

I changed it to this DoCmd.OpenReport "Volunteer_Requests_Report", acPreview, , "Volunteer_Categories_Table.Volunteer_Category IN(" & strWhere & ")" And got the following error syntax error(missing operator) in query expression "volunteer_Categories_Table.Volunteer_Category IN(general help)"...

I am trying to get this to work but I cannot figure it out. At this point I'm getting an object required error on the docmd.openreport line. I'm sure its because I don't have the where clause set up properly. If I debug strwhere it has the data for the where clause. The table has an id field...