I have a continuous form that displayes numerous records depenting on the search criteria in the HEADER section. Each record is actually information about a Quality Procedure, such as doc #, title, revision, etc... I want to add a button to the record to open the document. In other words, for each record displayed in the continuous form, there would be a button for that record that will open the document.

I do not know how to do this or even what the best approach is. Hyperlink? Attachment?

Please help

embedding documents in your database can cause severe bloat, I would personally go down the hyperlink route. You could use a button and use the Application.Followhyperlink method or just display the stored hyperlink and have users click it (no code required).

If its networked files make sure to use the full UNC path so you won't get any errors when different users are assigned different letters.

Jon

I have decided to go the routs of embedded attachments as this is a document library database and this is really the most secure way to store and distribute approved documentation.

My issue is opening the attachments. Right nor there is a continuous form that displays info for each document in the database and an "attachment" field / control is displayed for eash record in the form. Everything works fine but I would like a more efficient interface for the user.

As of now you have to click the "Paper Clip" then click the file in the pop up window then click "Open". Is there a way to replace this multi-click process with a command button that will open the attachment for the specific record?
Thanks

Anybody?