I have a DB that organizes controlled documents because I work in a regulated industry. I currently have a copy of the regulations saved as a PDF and use a hyperlinked command button on a switchboard to access and open the PDF. This works well until I move my DB or the PDF file is inadvertently moved (which my IT department sometimes does). I want to avoid this problem by making the PDF file an attachment in the DB.
To do this I created a table with an attachment field then I inserted the PDF file. My problem is that I can't figure out how to link actually opening the attachment with a command button. I'm thinking there's some basic VBA that points the button to the specific field within the record in the table. Let me know if you'd like me to post the DB.
As always, thanks for the help.