Combo box in query criteria

[nittany77]

I know this has been asked many times, I have searched those threads but can't seem to get this to work. I created a form with a combo box that nothing in control source, and another table in row source. In the query criteria I have [Forms]![Form1]![Combo0]. When I run the query I only get a text box where I can type in the data, the list does not pop up.



Any idea what I am doing wrong?

[Bob Fitz]

Is Form1 open, with a selection made in Combo0 when you run the query

[nittany77]

No it is not. I just tried it with the form open and a selection made and the data is filled in correctly in the query, but I still didn't get a selection box
.

[Bob Fitz]

That will be the reason that a dialog box opens, requesting the data for the criteria. If you open the form and make a selection from the combo before running the query, all should be good.

[nittany77]

But I want the selection box to pop up when I run the query, I don't want to have to open the form first and do it there. Is this possible?

[Bob Fitz]

But I want the selection box to pop up when I run the query, I don't want to have to open the form first and do it there. Is this possible?

So your problem is not that you have to enter data when the query runs, but when the data request is made, you want to display a combo box for the user to make a selection from. Is that correct?

[John_G]

Hi -

No, you can't put a combo box in a query and select from it there. You have to put the combo box on a form, make the selection there, and the run the query with the combo box VALUE in the criteria.

John

[nittany77]

Yes that is correct. I don't want them to have to type it in.

[Bob Fitz]

Yes that is correct. I don't want them to have to type it in.

IMHO users should only be allowed to open forms and reports. The data returned by a query should always be displayed in a form or report. So I would suggest a main form (unbound) with a subform in datasheet view which is bound to your query. Reference the combo on the main form in the criteria of the query. Instead of the user opening the query directly, they would open the main form. Let us know if you need a quick example of this.

[nittany77]

I think I understand what you are saying but an example would be great.

[Bob Fitz]

See if this helps:

[nittany77]

I see how these two are tied together, but I don't see how I would use this in my case. I just tried a different way, I made a form where I can select all of the data and then put a button to run the appropriate query from this form. The only problem is that my data I select on the form is not making it into the query even though I have those form items listed in the criteria on the query. Sorry for being so dense....

[Bob Fitz]

Can you post a copy of the db.

[nittany77]

See attached. What I would like to do is open the "query form", pick a start date, end date, and workcenter and get the appropriate data.

[June7]

Controls used for input of filter/search criteria must be UNBOUND, otherwise you change data in record.

Unless you want to move the search controls and button to the Form Header and display records in the Detail section, there is no reason to bind this form to data.

I never use dynamic parameterized queries. I use VBA code to build filter criteria and apply to the form or report when opened. Users do not work with tables and queries.

For some reason the query still shows input popups for [Start Date] and [End Date]. The macro appears to have some parameters set up. Get rid of them I guess. I don't use macros and don't understand these parameters. AhHa! Found them by clicking Parameters from the ribbon Design tab.