I have a form with a lot of fields, combos, subforms etc on it.
There is a print button to print an invoice which runs
DoCmd.OpenReport "RptPaymentRecord", acViewNormal, , "MemHeadOfHouseID = " &
MemHeadOfHouseID which works as expected.

If I change tis to DoCmd.OpenReport "RptPaymentRecord", acViewPreview, ,
"MemHeadOfHouseID = " & MemHeadOfHouseID Again that works as expected.

However if I try to print from the preview (^P) I get the error message “A
custom macro in this report has failed to run” Any ideas why?
Is s it a likely to be a wrong error message and should say something
misleading like “Too many databases open”

Many thanks

Phil