Adding file path names to an access record

[lrw0831]

I have an Access database that is used to keep track of issues that the department receives. What we need is a way to add attachments to issues, but only by adding the path name that is a hyperlink to open the document.

More information -

I need to open a form from the main issues form (which I can do that).

The attachment form needs to have a browse button that allows the users to search through their documents to find the file. I need to have a table for the attachments which will include the following:

Attach_ID
Description
FilePathName (hyperlink)
Issue_ID (which will link it to the main issue record)

The above needs to be included in the attachment form as well.

Also, each record can have many attachments. The users need to be able to open these documents by clicking on the path name.

Would the best solution be to have a textbox that then populates a listbox with all of the attachments for each record?

I'm not sure how to do any of this and would really appreciate the help.

Thank you

[ADezii]

This may help you:
How to Programmatically Add a Hyperlink to a Form