Hello everyone
I have tried to use a sql statement in access, where the field is a combo box. I load the query and write

SELECT * FROM TblOne WHERE field1 = 'choice'

field1 is a combo box.
The query does not work. what you think I might be doing wrong?