Mystery parameter request in report

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.
 
F

fredg

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.
 
F

fredg

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?
 
J

Jean

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.
 
P

PizzaBoy

Thank you for all the help. Sorting/Grouping still had a reference to the
old field.
 
Top