Combobox in a Query

[maquino]

Please help.
is it possible to put a combobox when I run my query? I know that I can specify a value by putting something like [Type the value] on the criteria of the field, but I want to be able to select the value, instead of type it, since the field is a combobox.
Thanks

 

[fernin8r]

I think i have a solution for you. I may not be the best one.

I would make a form out of the query and run the form in Data sheet view so it looks like your query. You can create a combo box on the form that will show up in datasheet view.

Hope this helps.

 

[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

 

[JLKRK]

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

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