Combo Box for Query CRITERIA?

[TUPJK]

I am constructing a query for a data list



What I want to know is is there a way I can insert a combo box sort of drop down menu list in the "CRITERIA" field of a query?

It would make it easier if I could select from a list instead of typing it in everytime I want to run the query

It would seem very bizarre if there isn't a way to do this, it seems very intuitive

[boblarson]

No, you can't do that in a query. But you CAN use a FORM for selecting criteria and then you set the criteria in the query to use the control in the form:

[Forms]![FormNameHere]![ControlNameHere]

[TUPJK]

No, you can't do that in a query. But you CAN use a FORM for selecting criteria and then you set the criteria in the query to use the control in the form:

[Forms]![FormNameHere]![ControlNameHere]

That's what I was fearing

what would be an example of a "control"? I'm confused about [controlnamehere]

[boblarson]

That's what I was fearing

what would be an example of a "control"? I'm confused about [controlnamehere]

That would be your combo box name.

Controls are:

Text boxes
Labels
Combo boxes
Listboxes
Option Groups
Checkboxes
Radio Buttons
Toggle buttons
Lines
Rectangles
... and more

They are basically anything that is on a form or report.

[TUPJK]

That would be your combo box name.

Controls are:

Text boxes
Labels
Combo boxes
Listboxes
Option Groups
Checkboxes
Radio Buttons
Toggle buttons
Lines
Rectangles
... and more

They are basically anything that is on a form or report.

Thanks Bob!

[BlueIshDan]

This should generate a form for you to go by
https://www.accessforums.net/code-re...orm-44282.html