Parameter Queries

[bgfs]

I have a parameter query which takes values from 4 comboboxes on a form. Typically the criteria is laid out like this in the query.

[Forms]![findfrm]![cbohard]

If all four fields are completed the query works fine. If I leave one or more fields however, the query returns a blank. Anyone know of a way to make the query use the information in just the completed fields and ignore the empty fields?

 

[dhookom]

Set the criteria like:

[Forms]![findfrm]![cbohard] Or [Forms]![findfrm]![cbohard] Is Null

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[bgfs]

Thanks, I found this before but the search form kept coming up with the criteria input box. I found that because I had added the criteria to the query at different times, when the null criteria had formed a new column in the query, they were out of sequence (At least I think thats what caused it) thanks anyway