Filtering by a combo box

[Dave H]

I have a main form which has a combo box which the user selects a value. Then I have 3 buttons, depending which button the user clicks it takes them to another form that would be filtered by the selection of the combo box. I have a query set up with the criteria as [Forms]![Form1]![cbo3]. When I choose a value in the combox box then click the button which has a macro to open the form I get a text box. If I then type the value in the textbox the form opens filtered correctly. How do I get the query to recognize the value selected in the combo box?

 

[pbaldy]

You're not closing the first form, are you? It has to be open for the query to get the value. If it is open, double check the spelling of the control.

 

[Dave H]

The 1st form remains open, I used the expression builder to get the control name. I'm stumped. ??

 

[pbaldy]

If you open the query directly from the database window, with the form open and a selection made, does it prompt you then?

 

[Dave H]

Yes, it still gives me the Enter Parameter Value textbox.

 

[pbaldy]

Then the reference to the form/control is somehow wrong. Can you post a sample db?

 

[Dave H]

What is the process for posting the sample database?

 

[pbaldy]

Compact it, zip it and attach it. It has to be under 393k once zipped. You have to be in the advanced reply mode to see the "Manage Attachments" button.

 

[Dave H]

I start with the form switchboard choose from the combo box then click the button federal.

 

[pbaldy]

That is weird. I wonder if that form is corrupt. I created another one and the same technique worked fine. Try that first, and I'm going to play with this when I get time and see if I can figure anything else out.

 

[Dave H]

Thanks so much for your help.

 

[Dave H]

I tried creating a new form and got the same result. Would you mind posting the one that you got to work and maybe I can figure out what the difference is. Thanks