I have an access database that has an attachment field. New to programming and have been at this all day. What I would like is for the entire field of attachments to read 'Open' and then click on that word open and it will open the PDF that is attached.

Example

LastName | FirstName | OPEN | Date | Notes | etc

I would just like to click the word OPEN and have the PDF associated with that contact open....