I did this a year ago and now can't remember how I did it! I have a table with 2 fields in each record, a job number and job description. I want to add another field to the record which is a link to a spreadsheet. I only want the spreadsheet to open up if I click on that field. Please help. Thanks in advance.

Hi
In table design add the field required and make the datatype = Hyperlink
Open the table and place your cursor in the hyperlink field
Use hyperlink button on Toolbar to link to File

Hope this helps
Mike

This attachment may help as well

Hi,
I would suggest you rather use a text datatype field instead of a hyperlink. Within that you can store the full string paths to the external files. Since users should never see the table or query level and only do what they are supposed to through an interface (forms) you can use the on click event of a control on a form bound to this table field to open up the file. To achieve that you can use the FollowHyperlink or Shell method e.g.:

Application.FollowHyperlink Me.YourControl

Where YourControl is the control bound to the text datatype table field holding the full string path to the file.
HTH
Good luck