If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreports not Saved in Main Report
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. |
#2
|
|||
|
|||
Subreports not Saved in Main Report
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 -- -Larry- -- "CarrieIHM" u53446@uwe wrote in message news:996abfda0b4ab@uwe... 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. |
Thread Tools | |
Display Modes | |
|
|