attaching a pdf to a record through a form

[yazzbee89]

I am working on a database that keeps travel information for the employees in my office. One of the things I need to do is create a way for the employees to go into the datanase after their trip and attatch their expense report to the form with their trip information. I need a button in the form that allows a user to attatch the pdf to their trip and a button to view pdf.

I have the hyperlink field in my table already but I cant figure out how to make the pdf stick.


I also am using code to create a box to open and browse for the document. Once the user chooses a file I have it assigned to the hyperlink property of the view report button but once the form closes it looses its data and the user cant go back and see the report.

 

[ghudson]

You have to save the current record to make the changes stick to your bound table.

I advise against using storing the path/file data as a hyperlink. Store it as text and use code to open the file when the user clicks a button.

Did you search the forum? Linking files to Access