Help! Cmd Button link to unique hyperlink stored in table

[Dimples]

ok, I have links to documents(reportLink) stored as type text in a table (Investigations). Each link is different per record.

I have a form that display information from this table. The field that holds the hyperlink is called reportLink on the form. On this form I would like to have a button that when clicked will open up the [reportLink] for that particular record. so this button will point to a different file each time the record is changed.

I have stumbled around this site and think I have to put the
Application.FollowHyperlink code in the OnClick event for this button. However, I am clearly not doing it right as it isnt working. what is wrong with this:

Private Sub Command34_Click()
Application.FollowHyperlink Me.[ReportLink]

End Sub

 

[Treason]

2 questions:

What file type is the document(reportlink)?

Do you have a control named ReportLink on your form, and what is the value in the field?

 

[Dimples]

1. The type of file is a pdf file.

2. I do have a control on my form named 'reportlink'. It shows whatever value is stored in the table for that record. 'reportlink' will be a differrent link/value for each record.