I can open 48 of my 50 forms using 'DoCmd.OpenForm', but it refuses to open 2 of my forms.
However, I can open the 2 forms no problem at all using 'OpenForm' embedded macro, and even with a "where condition" included.
WTH?
Many thanks. Everything working perfect now. Have attached a (zipped) mock-up db with just the necessary tables and reports for you to demo the ReportBBB. Thanks again.
Thanks. Have done as suggested, seems to be now bullet-proof in regard to the row splitting and over-printing problems. But still not re-printing the sub-report header on next page when an overflow occurs. Have experimented with adding page-headers to each sub-report, but no difference.
Thanks arnelgp. I removed the record source for the Items from the detail section and cleared the textboxes, leaving the detail section empty. Then made a sub-report for Items. Then added the Items sub-report, and the other sub-reports to the detail section. Excellent results obtained on page...
I have a report containing sub-forms that prints perfectly when all of the report sections fit on the first page.
It will also print perfectly onto the second page if the detail section is the section that overflows to the next page.
But, it all goes pear-shaped when the footer section which...