Hyperlink Issues

[Zanatos]

Hey Guys

I have been trying to get a hyperlink to work on my database, the database is full of values, and you can scroll between pages which is where I want my hyperlink to be (one on each page)

I have a way of naming my files as show below and after which I want to hyperlink that name and have it direct me to that exact file
How I name my files:


Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim MyString, MonDay
MyString = txbInspectionDocDate.Value
MonDay = Mid(MyString, 5, 1)
txbInspectionDocID.Value = txbInspectionID.Value & "_" & txbInspectionDocName.Value & "_" & MonDay
TXFileLocation.Value = txbInspectionID.Value & "_" & txbInspectionDocName.Value & "_" & MonDay & ".pdf"
End Sub



Right now I have a command button on each page, with a hyperlink to the directory file, but I want it to open the file itself, here is that code posted below:


Private Sub Command15_Click()
Application.FollowHyperlink "C:\Documents and Settings\ (**erased on here only, actuall link in my VBA**) \PDF Documents\", , True, True
End Sub





I cannot figure out how to open my TXFileLocation instead of the directory it is in, also I don't want it to be a command button, I just want it to be text you can click (I already have this text on my table in a textbox).

I am not very good with Access, so please detial any help you may provide.

Thanks!
Chris