About a week ago an expert helped me with a question that involved having the ability to open PDF files from a form. I want to take this a little bit further and have the user have the ability to open a PDF file, by double clicking the record in a listbox. Please see the attached Access file. Note that only PDF files will ever be used with this database.
The way I see this working is this...
1) A program administrator would add the files/records to the database via the use of the form, "frmLinkedPDF". These files in real use would be on a network server but for now for testing I'm just using a folder on my computer.
2) Then the end user would use the form "Form1" to select the PDF file they want to open/view/print. They would do this by double-clicking the item in the listbox.
I need help with the doubleclick event of the listbox.