Using quey criteria from a combo box?

[rick roberts]

i have a combo box in a form listing various people featured in pictures. i expected that if i chose a person from the combo and created a query with the criteria [Forms]![form name]![combobox name] in the person field then i would get a list of all pictures relating to that person -- this doesnt seem to work for combo boxes? -- if i change the combo box to textbox and insert a name --then it works. am i missing something very simple here?

 

[pbaldy]

It also works for combo boxes; make sure the bound column is the correct one.

 

[rick roberts]

you were right

combo boxes were bound to the wrong columns --i blame the wizard lol -thanks for replying