I have been searching all over for explanations of how to use selected data from a multi-select listbox as criteria in a query but I'm not very well versed in 'more advanced' VBA language. I've tried multiple different explanations that I've found online. I somewhat understand the 'multi-select for query criteria' concept but none of the explanations have worked - most likely because I don't know the language well enough to know what needs to be replaced specifically for my database or if I'm missing necessary fields. I'm using Access 2013.
I created dynamic combo boxes (cmbGroup and cmbInstructor) that filters the values that appear in the listbox -- this works as I wanted -> cmbInstructor updates based on the selection in cmbGroup, and listTripDates updates based on the selection of cmbInstructor. But I want the user to then be able to select one or more values from the listbox that can be used to run a query based on their selections. Attached are a couple images - frm_QueryBuilder is the userinterface; Query1 is the query design that I want made when the user clicks the "Query Belt Survey" button.
Attachment 22796Attachment 22795