I have a button on quite a complex form (with 3 combo boxes, 1 listbox and 3
continuous subforms, 1 with 2 combo boxes) This has a button which runs

DoCmd.OpenReport t "RptPaymentRecord", acViewPreview, , "MemHeadOfHouseID = "
& MemHeadOfHouseID No problem

The report again has 2 subreports.

If I try to print the report I get
"A custom macro in the report has failed to run, and is preventing the report
from rendering"

DoCmd.OpenReport t "RptPaymentRecord", acViewNormal , "MemHeadOfHouseID = " &
MemHeadOfHouseID Again no problem.

My only thought is the error message should be "Too many databases open"
Are databases open for both the preview and the print operation

Any other ideas gratefully received.

Phil