S
scarlo
Ok, here's the dilemma. 9 variables in drop downs on my form that
am using as values for a parameter query.
In my criteria for one of the fields in the query there is:
Criteria: [Forms]![Sort]![Contact]
Or: [Forms]![Sort]![Contact] Is Nul
This brings back information only if I put in a value on the form
when I don't put in a value the return is totally blank.
When I recode to:
Criteria: Where Contact Like Forms![Sort]!Contac
Or: Forms![Sort]![Contact] like "*
I get both the ones I need and all the rest (because of wildcard).
How do I get the search to return ONLY the value I put on the form
OR everything if no value is specified. Basically I want somethin
like:
Criteria: [Forms]![Sort]![Criteria
Or: Where Contact Like Forms![Sort]![Criteria] = null sub "*
When I put this all in the criteria line:
[Forms]![Sort]![Contact] OR [Forms]![Sort]![Contact] Is Nul
I get the correct response when I enter a dropdown selection on th
form (contact), but when I don't enter a contact I get nada...
Any advice
am using as values for a parameter query.
In my criteria for one of the fields in the query there is:
Criteria: [Forms]![Sort]![Contact]
Or: [Forms]![Sort]![Contact] Is Nul
This brings back information only if I put in a value on the form
when I don't put in a value the return is totally blank.
When I recode to:
Criteria: Where Contact Like Forms![Sort]!Contac
Or: Forms![Sort]![Contact] like "*
I get both the ones I need and all the rest (because of wildcard).
How do I get the search to return ONLY the value I put on the form
OR everything if no value is specified. Basically I want somethin
like:
Criteria: [Forms]![Sort]![Criteria
Or: Where Contact Like Forms![Sort]![Criteria] = null sub "*
When I put this all in the criteria line:
[Forms]![Sort]![Contact] OR [Forms]![Sort]![Contact] Is Nul
I get the correct response when I enter a dropdown selection on th
form (contact), but when I don't enter a contact I get nada...
Any advice