Two Reports into One

[Arfur Fuxache]

I have developed two reports that work perfectly as individual reports - (same as other thread) but I need them to print as one report in order that when the PDF printer driver is selected it outputs both reports in a single file as a PDF.

Report 1 is a quotation report with a sub report for the quotation line items.
Report 2 is an order form with three different layouts depending on the type of quotation.

I have tried including the order form as a subform of the quotation form but I seem to be struggling with:

1. The order form refuses to start on a new page, it just continues on from the main report.

2. The layout of the order form is totally dependant on the vba behind the report to drive content and visibility. I have set watches on this code but when run as a subform the watch doesn't even trip - To me this means it is not executing. I have tried on activation and on page.

Any help would really be appreciated

 

[GaryPanic]

Daft question
but why not have it as 1 report and have done with it - I know its a bugger getting this sorted but have the same sort of problem myself , and this is the only answer that I can come up with - their is pdf software that will combine reports into 1 report

If you come up with a better answer could you let me know

regards