Enter Parameter value for a changed field

[Anne]

I am re-working an existing database and I have changed several field names.
I created a new query for this report, but I am re-using an old report. In
the query, I have changed most the field names in the totals query to match
the report, because there are many similar reports to consider, which I do
not all want to re-do.

There is one old field which keep popping up and it keeps asking for the
parameter value. I checked and re-checked but I cannot find where this field
is used in this report. There is no error in the query. I checked sorting
and grouping. There is nothing like SQL view in queries. How can I find
where this old field is used?

 

[Marshall Barton]

I am re-working an existing database and I have changed several field names.
I created a new query for this report, but I am re-using an old report. In
the query, I have changed most the field names in the totals query to match
the report, because there are many similar reports to consider, which I do
not all want to re-do.

There is one old field which keep popping up and it keeps asking for the
parameter value. I checked and re-checked but I cannot find where this field
is used in this report. There is no error in the query. I checked sorting
and grouping. There is nothing like SQL view in queries. How can I find
where this old field is used?

Other places to check is in the report's Sorting and
Grouping list and in every control's control source
property.

 

[Jeff Boyce]

Anne

In addition to the additonal locations Marsh mentions, sometimes queries
have parameters explicitly defined. Check the query(s) underlying the
report(s). Check the explicit parameter definitions/property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Anne]

I checked all that and I still cannot find it. I was hoping I could find a
list of all fields in this report somewhere.

 

[karl dewey]

Under TOOLS - Analyze - Documentor select the report and under options select
Names. Click OK. On icon bar select Analyze with Word and save file.
Open the . rtf file and search for the field name.
--
KARL DEWEY
Build a little - Test a little

I checked all that and I still cannot find it. I was hoping I could find a
list of all fields in this report somewhere.