Cannot open any more databases

[bbbum]

Hi,

I have a report, which by necessity contains 12 sub
reports. I print it with a "Print" cmd button on a form
that contains 12 sub forms, and opens the report showing
the desired record(s) using a WhereCondition. As I open
the report I set the visible property of the form to no,
so that I can easily return to the same record(s) on the
form when the printing is completed.

I want to open the report with acViewPreview, and when I
do the report previews correctly, but when I click the
print button on the report toolbar, the error
message "Cannot open any more databases" appears 6 times,
then the report prints but is missing 6 of the sub reports.

I have found by testing that if I close the from, instead
of just making it not visible, that my report will print
without problems. The form and the report use the same
left join query as the data source, and the sub reports
and sub forms most all use tables as the data source. I
can provide more exact details if need be.

I have read on one other forum that this situation is the
result of an internal constraint within Access on the
number of open objects, but there was so little detail to
that information that I'm seeking the assistance of
someone who can shed more light on the problem, and to see
if there is a way to fix the problem without extensive
redesign of the way I print these records.

My application is designed using Access 2000.

Thanks a lot!!