So, you need to open Explorer to display pdf files in a folder?
Is the folder always the same?
When the user selects the pdf file you want to store it's path in the table.
Does there need to be some kind of verification that they open the correct pdf file?
You then want to be able to open the pdf file to view the data.

What version of Access are you working with?