#error in report when using [enter] criteria in the query

  • Thread starter Thread starter Rafe Hastings
  • Start date Start date
R

Rafe Hastings

The query returns good data w/ or w/o the criteria [enter
MCN]... The report however, works as long as we don't
have the criteria specified for the "MCN" field. All
fields in the report result in "#error" when we have the
criteria specified as [enter MCN]. Additionally, the
report works fine when we set the criteria to
like "variable".... The report only returns the records
that are equal to the "variable" which is what we're
trying to obtain from an input. Any help is appreciated.
 
Does your parameter query return any records? If not, you will get errors in
most calculated text boxes in headers and footers.
 
Yes, The parameter query works fine by itself. I can run
the query independant of the report, and it returns the
appropriate records. When I run the report, and enter the
exact same parameter, the report gives me "#error". When
I remove the parameter from the query and run the report,
it provides an error free report. Thanks for the response.

Rafe

-----Original Message-----
Does your parameter query return any records? If not, you will get errors in
most calculated text boxes in headers and footers.

--
Duane Hookom
MS Access MVP


Rafe Hastings said:
The query returns good data w/ or w/o the criteria [enter
MCN]... The report however, works as long as we don't
have the criteria specified for the "MCN" field. All
fields in the report result in "#error" when we have the
criteria specified as [enter MCN]. Additionally, the
report works fine when we set the criteria to
like "variable".... The report only returns the records
that are equal to the "variable" which is what we're
trying to obtain from an input. Any help is
Click to expand...
appreciated.


.
Click to expand...
 
Could you be more specific 'report gives me "#error"'? Where do you get
this? In all text boxes or some or in a pop-up dialog? If in just a single
text box, what is the section and control source?

--
Duane Hookom
Microsoft Access MVP


Rafe Hastings said:
Yes, The parameter query works fine by itself. I can run
the query independant of the report, and it returns the
appropriate records. When I run the report, and enter the
exact same parameter, the report gives me "#error". When
I remove the parameter from the query and run the report,
it provides an error free report. Thanks for the response.

Rafe

-----Original Message-----
Does your parameter query return any records? If not, you will get errors in
most calculated text boxes in headers and footers.

--
Duane Hookom
MS Access MVP


Rafe Hastings said:
The query returns good data w/ or w/o the criteria [enter
MCN]... The report however, works as long as we don't
have the criteria specified for the "MCN" field. All
fields in the report result in "#error" when we have the
criteria specified as [enter MCN]. Additionally, the
report works fine when we set the criteria to
like "variable".... The report only returns the records
that are equal to the "variable" which is what we're
trying to obtain from an input. Any help is
Click to expand...
appreciated.


.
Click to expand...
Click to expand...
 
Back
Top