Mystery parameter request in report

  • Thread starter Thread starter PizzaBoy
  • Start date Start date
P

PizzaBoy

Hello Group,

I have a report based on a query. The report was copied from another
database I am using. The current report requests the proper parameter when
opened but then requests a field from the old report that no longer exists.
The ghost/mystery field/parameter is not in the report or in the underlying
query. How do I get rid of it? Where do I find it?

Thank you for your help.
 
Hello Group,

I have a report based on a query. The report was copied from another
database I am using. The current report requests the proper parameter when
opened but then requests a field from the old report that no longer exists.
The ghost/mystery field/parameter is not in the report or in the underlying
query. How do I get rid of it? Where do I find it?

Thank you for your help.
Click to expand...

There is a reference to this mystery field somewhere in your report.
The usual 'culprit' is the Sorting and Grouping dialog where there was
once a reference to a field used to either group on or sort by that
has since been eliminated. Remove the reference, problem gone. Another
place to search is in the code for that report.
 
Thank you for the help. How do I look at the actual code for a report?
Click to expand...

In Report Design view, click
View + Code

Then click on
Edit + Find
Enter the name of the control that is being prompted for.
Click Find Next

I still would put my money on the Sorting and Grouping dialog.

Did you check the accuracy of the spelling of all of the controls in
the Report?
 
Go into the design of your report. Make sure you have the
report design toolbar active(Standard toolbar Option).
You will see a button that is multi colored and when you
put your mouse over it says code hit that. Goes into the
code that corresponds with that report.
 
Back
Top