Search results

I could not get that to work. I think what I need is something like this just in expression. Query speaking here. If the field named (x) is null then pull all values, if the field has data in it then pull that value. Or On the form if there is some way to put the default value to wildcard...

Does that go in the default value of the field or in the query? There are no Null values in the field. I want the query to display all values if the form is null, or display values only by what is typed in the form.

Ok thanks that works great. I am trying to do the same thing with a text box in the form. As long as I have data in the form it works but if there is no data in the form I want it to bring all items. Is there someting I can set its default value to, and make this work?

I am having trouble using a form to define parameters in a query. I would like to have the query look at the form and query by that. First I want to make a selection in two check boxes, I have the fields set up as yes/no and I need to query based on both. Right now I can get the query to run...