Form for Search Query?

[eyal8r]

I thought this was a simple task- but it's proving otherwise. I have a form with a number of combo boxes on it. I want to pass the values selected in the combo boxes to the query, and return the results. Basically, it's a 'search' form. However, it's not returning anything. I used the expression builder to select the right combo box expression in the query- so I know that's right. What am I missing here?

For example- I have a combo box for City. I want to select all the records in a specific City. The combo box has a 'Select Distinct' type statement in it- and it's displaying the City names properly. I have linked a button to Query I am using. But when I select a city from the list (yes, multi-select is turned on) and hit the button- it returns 0 records. What am I missing here?
Thanks!

 

[Michael J Ross]

You say you have a number of combos, are these all referenced in the query? If so you will have to select a value from each of the combos for the query to work.

If you dont want to select from each combo when you run the query you need to change the referencing in your query to [Forms]![FormName]![ComboName] OR [Forms]![FormName]![ComboName] Is Null