Report limits on subreports

[asc4john]

I have a number of reports, over 50. Virtually all have three sections
in common. The remaining sections, usally no more than two, are
specific to the report.
Changes to common sections require me to edit 50 reports. So I have
now made about ten subreports. However when I add two subreports and
then try to view the report Access crashes.
Also when setting master/child keys I get "apllication defined error
or no object"
I've checked that the VBA modules do not have conflicting variables
the few needed globals in modules are declared as private. All the
querys work as required. Field names are not reserved words. Autocheck
is off. Is there some sort of limit to the number of subreports Access
supports?

 

[Gina Whipp]

asc4john,

There is a limit... you have not reached it! (If memory servers me it's
22.) Have you Compiled your code?

--
Gina Whipp
2010 Microsoft MVP (Access)

http://www.regina-whipp.com/index_files/TipList.htm

I have a number of reports, over 50. Virtually all have three sections
in common. The remaining sections, usally no more than two, are
specific to the report.
Changes to common sections require me to edit 50 reports. So I have
now made about ten subreports. However when I add two subreports and
then try to view the report Access crashes.
Also when setting master/child keys I get "apllication defined error
or no object"
I've checked that the VBA modules do not have conflicting variables
the few needed globals in modules are declared as private. All the
querys work as required. Field names are not reserved words. Autocheck
is off. Is there some sort of limit to the number of subreports Access
supports?

 

[asc4john]

Complied clean.
Also when I add the subreport the wizard asks for keys, which works
fine.
But in the propertry sheet for the main report I can define the keys
by typing them in, but if I click on the dropdown the little pop-up is
blank, like just a white blank.

 

[Gina Whipp]

Oops, sorry for delay! Are these reports bound to a RecordSource?

--
Gina Whipp
2010 Microsoft MVP (Access)

http://www.regina-whipp.com/index_files/TipList.htm

Complied clean.
Also when I add the subreport the wizard asks for keys, which works
fine.
But in the propertry sheet for the main report I can define the keys
by typing them in, but if I click on the dropdown the little pop-up is
blank, like just a white blank.