I currently have a database where I'm using a combo box on a form to return criteria from queried data. The current structure I have listed in my query critiera is Forms![Name of Form!][Name of Combobox!]. This works perfectly fine...

The problem I have is I want to allow the user to select more than one parameter on the form and have the query return the results on each of the options the user selected. I know I have to first change my combobox to a listbox (cause combo boxes can't be used to select multiple lines), and change the list box to allow the user to select multiple lines (Multiselect set = Simple). I first tried setting this listbox up the same way I set up my combobox i.e[(forms!)(name of form!)(name of listbox!)] but that does't return any results for me.

Can someone please help me try and understand what it takes to have a database return results off multiple options selected in a listbox???

Thanks!