Subreports not Saved in Main Report

[CarrieIHM]

Hi, I have multiple identical reports pointing to tables that are identical
in structure but with different data sets. Each of these reports also has
two subreports. After creating the first report, I made the others by
copying the original and changing the control source to the corresponding
tables/queries/subreports. I find that the copies will not "keep" the
correct control source after I save them, but revert to the control source of
the original report from which they were copied. I am using Access 2007.
Any ideas before I pull my hair out? Thanks.

 

[Larry Daugherty]

Doing it the way you have done you should have three sets of
separately named subreports: Report1, subreport1A, subreport1b;
Report2, subreport2A, subreport2B, etc. ...

However, your schema is wrong, so *don't* do it that way.

If the structure of 3 tables is identical then all of the records
belong in *one* table with a single field determining which of the 3
members of that attribute (you didn't explain what it is) belong in
this record. For purposes of discussion the attribute could be Color
and the members could be Red, Blue and Green. If the related
structures are also identical then a similar re-combination and
differentiation should be workable.

You can and should use a "launcher" form to select the Color from a
combobox and make any further selections necessary for the subreports.

Your mileage may vary.

Let us know how it works out.

HTH