Basing a query on a combo box field

[fredd_ie]

hi, sorry, there might be a really easy solution. tried searching but to no avail.
i have created a query based on a table. however, when the criteria for the field with a combo box is searched, it does not work! is there a way to get around this problem.
e.g. Table =Cars
Field with combo box =Make
When search for BMW, does not show cars even though there are some in the table.
thanks, fred

 

[joeselch]

If the value that is stored in the make field is a string, then the criterion must be enclosed in quotation marks - e.g., "BMW"

If the value that is stored in the make field is a number (say, the primary key value from your makes table), then the criterion should be a number and not enclosed in quotation marks - e.g., 2 (where 2 is the id number corresponding to BMW)