Multiple Combobox Selection passed as query criteria

[JLKRK]

I replied to an old thread and was just concerned it wouldn't get noticed. If anyone can help with the below listed it would be greatly appreciated.

This is fantastic and have utilized this, but now I have an additional question. First, when I want to change the combo box property to support multiple clicks (this I know how to do), but what should the criteria field look like to support one, many, or all values selected. Again, if
[forms]![myFormName]![MyComboBox] returns the query based upon one value selected, what should the criteria look like to support multiple combo box selections? Thanks, Jim

Shane Mc

Quote:
Originally Posted by Shane_Mc
Or, create a form with just a combo box containing your values on it.

In the criteria field of the query enter something like this:

[forms]![myFormName]![MyComboBox]

Put a command button on the form to run the query after the selection has been made in the combobox

 

[dcx693]

A combo box, by definition, is a drop-down list where you can select only one value. I think you'll want to use a listbox instead. It's very similar to a combo box, but will allow you to select multiple values.

Take a look at this thread for info on how to use the multiple selections in a query: Multi Select List Box --> Query

 

[JLKRK]

More questions

You're correct, my mistake, I meant list box. Unfortunately it looks like the thread you referenced didn't end in success. To be honest that was a little complicated for me and would need that broken down into a little more basic (like copy and paste to a specific area). However I was hoping to be able to do this in the criteria line of the query. Is that not possible? Still looking for a good solution. Jim

A combo box, by definition, is a drop-down list where you can select only one value. I think you'll want to use a listbox instead. It's very similar to a combo box, but will allow you to select multiple values.

Take a look at this thread for info on how to use the multiple selections in a query: Multi Select List Box --> Query

 

[dcx693]

I was hoping to be able to do this in the criteria line of the query. Is that not possible?

It is not possible when using a multiselect listbox to simply reference the control in the criteria line of your query. It's because the listbox returns more than one value. Here's another article that might be clearer for you: Use Multi-Select List boxes as query parameters