Query criteria

[border20]

I have a query wich is exported from a form...

I this form, i have a drop down menu that contains search criterias...

I had the folowing code in my query in the criteria field:
[forms]![formname]![dropbox]

but when the dropbox is empty, i want the query to display all the records as if there was no criterias...
how do i do this ?

thx

 

[casey]

I'm not exactly sure of the set-up, but perhaps if you've used the following criteria for your query...

Like [forms]![formname]![dropbox]

instead of...

=[forms]![formname]![dropbox]

I don't know if that helps. Let me know.

 

[David R]

Like "*" & Forms!FormName!FormField & "*" will do what you want, but it will slow down the query considerably.

 

[Pat Hartman]

Try the following:

=[forms]![formname]![dropbox] OR IsNull([forms]![formname]![dropbox])