I have several records that I would like to add a pdf file to. On clicking a button I can get the file to open externally (Adobe reader) but only if the file name is in the code. How would I get it to open the filename that is stored in a form control?
This code works
Private Sub Label1689_Click()
Application.FollowHyperlink "d:\MDF Database\Images\FileName.pdf"
End Sub
I tried
Private Sub Label1689_Click()
Dim strPDFfile As String
strPDFfile = [strPDFfile]
Application.FollowHyperlink strPDFfile
End Sub
But it fails, how to I get it to work?
This code works
Private Sub Label1689_Click()
Application.FollowHyperlink "d:\MDF Database\Images\FileName.pdf"
End Sub
I tried
Private Sub Label1689_Click()
Dim strPDFfile As String
strPDFfile = [strPDFfile]
Application.FollowHyperlink strPDFfile
End Sub
But it fails, how to I get it to work?