Selecting No Parameter from a List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used the instructions in the help file to create a report that uses a
dialog box to prompt the user for a parameter.

Everything works fine, except I would like all records to be displayed in
the report if the user doesn't select a value from the list box. Presently
the report gives me an #ERROR.

Any thoughts?
 
-----Original Message-----
I have used the instructions in the help file to create a report that uses a
dialog box to prompt the user for a parameter.

Everything works fine, except I would like all records to be displayed in
the report if the user doesn't select a value from the list box. Presently
the report gives me an #ERROR.

Any thoughts?
.
Try a parameter query in the format:-
Click to expand...
< Like [Which record is required ?] & "*" >
Entering "w" will return all records beginning with "w"
"wi" will return all records beginning with "wi"
no entry will return all records.
 
I tried the following and it did not work:

IIf([Forms]![City/State Selector]![txtCity]="","*",[Forms]![City/State
Selector]![txtCity])

BEK said:
-----Original Message-----
I have used the instructions in the help file to create a report that uses a
dialog box to prompt the user for a parameter.

Everything works fine, except I would like all records to be displayed in
the report if the user doesn't select a value from the list box. Presently
the report gives me an #ERROR.

Any thoughts?
.
Try a parameter query in the format:-
Click to expand...
< Like [Which record is required ?] & "*" >
Entering "w" will return all records beginning with "w"
"wi" will return all records beginning with "wi"
no entry will return all records.
Click to expand...
 
Also tried:

NZ([Forms]![City/State Selector]![txtCity],"*")

and

IIf(isnull([Forms]![City/State Selector]![txtCity]),"*",[Forms]![City/State
Selector]![txtCity])

neither was successful in returning any rows



BEK said:
-----Original Message-----
I have used the instructions in the help file to create a report that uses a
dialog box to prompt the user for a parameter.

Everything works fine, except I would like all records to be displayed in
the report if the user doesn't select a value from the list box. Presently
the report gives me an #ERROR.

Any thoughts?
.
Try a parameter query in the format:-
Click to expand...
< Like [Which record is required ?] & "*" >
Entering "w" will return all records beginning with "w"
"wi" will return all records beginning with "wi"
no entry will return all records.
Click to expand...
 
Try a parameter query in the format:-
Click to expand...
< Like [Which record is required ?] & "*" >
Entering "w" will return all records beginning with "w"
"wi" will return all records beginning with "wi"
no entry will return all records.
Click to expand...
.
Base the report on a query, which must include all
Click to expand...
required fields, with the above 'Parameter query in the
relevant query column, in the first criteria line.

On opening the report a dialogue box will appear asking
for data, answer as above
 
Back
Top