Report / Sub report data source lost when adding a new sub report

[Guest]

I’m trying to build a main report with 4 subreports in Access 2000. The main
report seems to lose the data source of one or more of the sub reports –
usually at insertion of the 3rd one. This is the first time I’ve encountered
such strange behaviour. Any ideas please?

 

[Duane Hookom]

What do you mean by "The main report seems to lose the data source of one or
more of the sub reports"?

 

[Guest]

The SourceObject property of the 3rd and subsequent sub report objects is
lost or corrupted (changed to point to the 1st sub report). The link fields
are maintained.
The sub report objects are all placed in the main report.

 

[Duane Hookom]

I have never heard of this happening without some code that would
dynamically set the properties. I suggest you replace/re-create your report.

 

[BabyATX13 via AccessMonster.com]

Joe,
are your subreports in the report footer? if not, try them there.
KB

 

[Guest]

Problem still persists - I guess I've got a sick database. I have managed to
set the data sources in code, but it's still a bit of a worry that something
is lurking in there waiting to pounce. If it happens again I'll try kicking
the tyres.

Many thanks for the advice.

Joe.