Query criteria bvia combobox

[Vaporhead]

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

[orange]

Is the form open when you run the query? Result??

[Vaporhead]

Yes, the form is open and the appropriate combobox selection entered. The query will show now results.

[ArviLaanemets]

What kind of info contains tblMishaps.[Store Location] (location id, or some coordinates, or location description)? And is it's format long integer, or number, or text?
What is the RowSource of combo, and which column of row source is BoundColumn? And what is format of BoundColumn column, in case RowSource is a query?

When your query doesn't get any results, the most probable reason is, you compare non-comparable values in WHERE clause.

[June7]

I don't use parameterized queries. I use VBA to build filter criteria and apply to form or report.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Vaporhead]

Sorry for not replying back. I ended up recreating the query it it's functioning fine now....