Query criteria in Access 2007

[MishkaNanook]

Good Morning,

Can you still use criteria such as;

=[Forms]![FormName]![FieldName]

in the criteria field of a query in Access 2007 where [FormName] is the name of the form and [FieldName] is an unbound combo box which is pulling its data list from a table.

I've used similar statements before and they worked well; however, I've now updated the database from 2003 to 2007 and need to create a new query and I don't seem to be able to get it to work.

Any help or suggestions would be greatly appreciated.

Thanks, Nicole

 

[pbaldy]

Yes, it should exactly as before. What's the SQL of what fails? Is the form open, and focus off the control?

 

[MishkaNanook]

Yes the form is open, with data in it, yet when you run the query it always returns with no matches.

 

[pbaldy]

Since it's a combo, make sure the bound column and the field in the query contain the same data. You may be comparing an ID field to a text field.