Copying Report from another database

M

Michele

I have copied a report from a database (Northwind) into another database.
Actually, it's for mailing labels. Once I had it copied into the new
database, I changed the Record Source to reflect the new database. I also
checked all the fields to make sure they were named correctly. When you open
up the report, it's looking for parameters that existed in the source
database, such as country, etc. The new report is tied to a query that does
not have those parameters. Can you help me? Thanks for your help.

Michele
 
R

Rick B

If you don't have (or want to use those items) then take them out of your
report.
 
M

Michele

Therein lies the problem. These extraneous fields don't show up in the field
list.
 
R

Rick B

That is the point. If they are not in the field list, you can't use them in
the report. You must have them on your report somewhere, or in the sorting
or grouping. They may even be in the code, in conditional formatting, or
used in a 'default' value for a field. Find them and remove them.
 
M

Michele

Oh. Okay. Time to "play" detective. Thanks for your help. I didn't think
to look in other places.
 
Top