I have created a form in my database which I allow users to attach supporting
documentation.

When the documents are attached I change the file name to include the record
ID number, date attached, revision level and then copy the file to a
controlled location on my server. I then only store the file path in Access
to keep the database small and fast.

When the user wants to view the file they select the name from a listbox
with writes the file path as a hyperlink code into a command button. Then the
user clicks the command button to open and view the attachment.  

Q1: How could I write the code so when the user double clicks the list box
the file is opened in its correct application without the intermediate step
of clicking the command button?