Report with subreports moving from 2003 to 2007

[Betz]

We have just begun testing our applications in Access 2007. I have a report called Master with 12 subreports called Child01 - Child12. Each subreport pulls data from a different table/query. In Access 2003 it works fine, however when opened with Access 2007 it does not get beyond 'Formatting page'. It requires CTRL + BREAK to stop. Also, if I remove Child09 - Child12 it works.

Does Access 2007 have restriction on number of subreports OR can anyone point me in the right direction of a method to use Access 2007?

 

[Remou]

Does each subreport work by itself? Do the subreports use code/macros and does you security level allow code/macros?

 

[Betz]

Sorry, I should have included that in first post - Each subreport tested seperately works fine. Subreports do not use code/macros.