Link PDF files

What would be the best way to link pdf files in an Access database form?

For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and then link the pdf files.

I started but am having problems with Access not opening the pdf file, it will open word files but not pdf, might be just my computer.

Anyway suggestions would be appreciated. Thanks

Have a look at my attached sample, it will open both word and pdf files.

Have a look at the code behind the "Open PDF" button. You will see that you have to tell access where the Acrobat.exe is.

Before you use it, open both of the tables and change names & paths to suit your situation.

Hope this helps.

Thanks so much that worked great!

John I know you did this years ago but i just want to thank you too. this was EXACTLY what I needed