Combining 4 reports into 1

[jeaves79]

Ok, so I have Access 2007 a report that I run alot during the course of a day calls 4 print jobs. How can I re-write the followin code so that when I hit print, it doesn't print out each report seperately?

DoCmd.OpenReport "Rpt Fax Cover", , , "[Batch] = " & [ImportDataList]
DoCmd.OpenReport "Rpt Flex EPA Page1"
DoCmd.OpenReport "Rpt Flex EPA Page2"
DoCmd.OpenReport "Rpt EPA Datasheet wBD", , , "[Batch] = " & [ImportDataList]

The reason that I ask is tha tI'd liek to print to a PDF, and I have Adobe Write rinstalled so that I can print directly to a PDF, except i hav eto save 4 different files and then combine them in Adobe. That is time consuming when I am pretty sure I can have access combine them all into 1 report.

 

[khawar]

You can use sub reports to get all this in one reports

 

[jeaves79]

I am an amature Access user. I inherited this databaase when I got the job, and I have been able to make some small improvements, but i don't know how to do subreports, how would it look?

 

[khawar]

Search for sub reports in access help and on this forum

 

[jeaves79]

OK so now I have the Report with the Sub-reports, so that it prints all of them at once, except it is picking up all of the data, it is ignoring the Where statement:

DoCmd.OpenReport "Rpt Total EPA", , , "[Batch] = " & [ImportDataList]

Any ideas?

 

[khawar]

What is this ImportDataList (means is it a text field or what)

 

[jeaves79]

It's the selected line in the form that i use to select which shipment I am printing.