Running a query by a selection from a combo box

[trackmedic]

I have a query that runs info selected from safety visits. I have made a form with an unbound combobox that selects the supervisors name and after the name is selected, I have a button to run the query. When a name is selected, the query comes up blank. When I do not select the name, the query is populated.

My criteria on the query is [forms]![personnel]![combo9]

Combo9 is the unbound dropdown menu with the supervisors name that is taken from a table of names.

Any help?

Thanks in advance.

 

[pbaldy]

At a guess, the bound column of the combo is not the same data as the field in the query with the criteria (ie an ID number instead of the name).