Query using a combo box??

[Dave H]

I am trying to use a combo box and then a command button to open another form that would be filtered by the combo box on the first form. My command button macro reads where condition [Forms]![Form1]![Combo3]=[Query1]!

 but when I click the command button I get a popup that says Enter Parameter Value  Forms!Form1!Combo3.  If I type the value in my second form opens filtered correctly.  How do I get the query to recognize the value in the combo box?

 

[KenHigg]

I have no idea if this will fix anything but isn't the filter written backwards?

Should it be:

[Query1]!

=[Forms]![Form1]![Combo3]

???

 

[rainman89]

make sure u specify what column you want (that has what value you want filtered on)

so if its bound to a column you should be ok.. if not make sure its

[Forms]![Form1]![Combo3].column where n is the column # starting at 0

 

[Dave H]

Ken when I switch them I get the same error.

Ray when I try the column set at 0 because I want the 1st column I get the error "Undefined function'[Forms]![Form1]![Combo3].[column]' in expression."

What am I doing wrong?