Query criteria from combo box on form (1 Viewer)

[belly0fdesire]

I can't figure out what I am doing wrong... I want the query criteria to be defined by a combo box in the form. The user will select the criteria on the combo box, then click a button to run the query, however the query keeps coming up blank.

[Forms]![UserReview]![Staff] is what I have entered in the criteria for the field in the query. If I simply type in "casbds1" as the criteria, which is one of the choices in the combo box, it returns with the data I want, but I just can't get it to work with the combo box. Any ideas what I am doing wrong?

 

[edtab]

Check what column you have bound in your combo box.
Usually, the first column (primary key), by default gets bound when you
create a combo box. Try binding the column that contains
the data you want.