Enter Parameter value for a changed field

  • Thread starter Thread starter Anne
  • Start date Start date
A

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?
 
Anne said:
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?
Click to expand...
Other places to check is in the report's Sorting and
Grouping list and in every control's control source
property.
 
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
 
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.
 
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


Anne said:
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.
Click to expand...
 
Back
Top