Collate single record report and existing pdf (1 Viewer)

[mdcory]

Hi all. Using Access 2003 I am trying to figure out how to print and collate a report and an existing pdf file that is opened based on a field in the record. I figure that it probably has to do with looping through the records but I am not very good at that.
So I have a form with a sub form that opens records based on a combo box. I then have a report (a checklist sheet) that prints 1 page per record. I would like to print a pdf file associated to that record before it prints the next record.

Here are the names of the objects being used:
tblMoveDoc
frmMoveDoc
subfrmMoveDoc
rptCheckList

Any help would be appreciated.
Thank you,
Matthew

 

[philipavery]

Do you mean, print a page of the report and then a PDF, then the next report page, and so on?

 

[mdcory]

Yes, exactly.

 

[Rabbie]

Have you tried firing off the .pdf print from the on Print event of the page footer.

 

[mdcory]

No, I hadn't Rabbie, I didn't even know it was there. Now I guess my next question would be is what code do I use to print the pdf?
Thanks,
Matthew