Query Returning No Data When it Should

[thabounceisback]

I have a Query that runs off of a combobox selection as it's criteria.
Specifically the criteria is:

[Forms]![Print Coupon Form]![EECmb]

Is this not the right syntax? Do I need to specify the column within the combobox that matches the field that I am using the criteria on?

Why isn't this working?

 

[pbaldy]

That would use the bound column.

 

[thabounceisback]

That would use the bound column.

And that is what I want. It just is not returning any data for some reason.

 

[pbaldy]

Can you post the db?

 

[thabounceisback]

See attached.

 

[pbaldy]

The bound column is 1, which is the name. The criteria is on the employee number field. Changing the bound column to 2 seems to work.