Change Table in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had a report written, but changed the source table and went and manually
altered all of the control sources on each field. When trying to print
preview, I get a 'Enter Parameter Value' box for the new table name. When
clicking OK, each field is listed as #Error.

I presume I must have missed a field or only partially entered the control
source. Is there a quick way to check where this could be, rather than check
every field in the report?

Thanks
 
Andy,
First, are you basing the report on a table or a query. If a query, does that run
without a prompt?
If yes, then that field reference is on the report. Otherwise, it's in the query (at
least) (I'm assuming it is on the report)
If we assume it is on the report... I'll use [XYZ] as the field that cannot be found...


1. On the report, first check your Sorting and Grouping for any reference to XYZ. (bet
that's it)

Here's a trick...
2. Make a backup of the report under another name. Now "cut" half the fields from the
and preview. Get a prompt?
Paste those fields back onto the report, and "cut" the other half of the fields.
Use that method to drill down to the field/s that may be causing the prompt.
If you make a cut/paste error, try again with your backup.

3. Check all your macros or module code, if any.
4. Don't forget to do the same for any subreports.
 
Back
Top