Hello.
I have a form [frmStoreProfile] with a combo box [cbolocation]. The combo works just fine within the form, but when I use the [cbolocation] field for a query criteria, I get no results. If I close the form and run the query, I get the expected results after I type in the [cbolocation] parameter, but with the form open and run the query, I get nothing.
My WHERE clause in the query is: WHERE (((tblMishaps.[Store Location])=[Forms]![frmStoreProfile]![cboLocation]))
It seems like the query is not pulling the cbolocation value from the form.....
Mark