Access Access Reports

[rustaferd]

I have created an Access Database to create, track, search, and print MSDS pdf files.
In my database, each record has a link pointing to a specified MSDS pdf file.
When I select my print button the pdf file for that record will open. I can then print this pdf file.
Is there a way to create a print button that will open the first record, then open that records link to the pdf file, then print that open file, close it, then go to the next record in line and do the same thing, all the way through the database records?
Normally you could create a report if the data was embedded in the database,but because the information I need can only be accessed by a link, it becomes tricky how best to do this.

Thanks for your help,

Russ