Change record source of a report

[Linda]

I have a report based on a table. I want to make another report just
like the first one except based on a different table. I opened the
first report, right clicked in the report and chose "save as" and
saved it as a new report. I then opened the new report's properties
and changed the record source to the new table which has the same
fields as the first table (same names & everything). Now there is a
message next to the text boxes in the report that says "Invalid
Control Property: Control Source". I checked the properties of the
text boxes and it is the right table and field from the table. What am
I missing?
Thanks.

 

[Guest]

Linda,

Make sure you are editing the new report. If you are editing the New Report
and still getting the "Invalid Control Property: Control Source", I have
found that I sometimes need to re-establish the links (this might also mean
force the report to re-compile- atleast that is how see it) between the Table
and the objects on my report. Remember you just changed the name/source for
the report, now each object in the report, that was getting data from the old
source, needs to change it's own settings to point to the new source, and
that is assuming/guessing that you kept the field names in the new Table the
same as the prior Table, and that all the properties (numeric fields are
still the same, numeric or alpha,etc..). Try running the report and then go
back into edit mode and see if some of those Invalid Control Sources clear up
on their own. If not, then go in and edit (the individual objects/text boxes)
them and point the source (for that object/text box,etc..) to the correct
field in the new table. You will still end up saving more time, than
starting from scratch, and the spacing will be just like the originial report.

You may also want to edit the report properties - under format, Caption and
change the caption to the New Name of the Report too.

I hope a MVP will correct or add anything I missed,
Good Luck,
Steve