View/Print PDF attachment in report

[bnecrush]

I am trying to find out if there is a way to view/print a PDF attachment in a report. The PDF is an "Attachment" in the table. The report gathers data between two specified dates thru a query, shows multiple (as few as 1 and as many as 30) records for that range. For each record there is a PDF attachment that also needs to be printed. Currently we open each record individually then print the attachment, print the report and "match up" each pdf with the record in order of appearance on the report. Is there a way to have access print the PDF attachments after the report in order of appearance on the report? Basically becomes a huge time saver when printing the report.

[RuralGuy]

I would think you could automate in code what you are doing by hand. What are the manual steps?

[bnecrush]

RuralGuy, THANKS, there are actually a couple steps. First there is a form generated between the specified dates, there is a command button on that form that opens the entry, we then open the attachment and print the PDF attachment, close that record and go to the next record. After each one is printed then we run the actual report (invoice) and attach each PDF in the order it appears on the report.

[RuralGuy]

Hmm...any chance you could post something I could play with? You can PM me if you don't want it to be public.