Dynamic hyperlink in form

[mnemosyne]

hi i'm trying to figure out how to have a hypertext link in a form use the information entered from a separate field in order to link to a word document

EXAMPLE
Link to Report is a hyperlink that gets the Medical Record # from another field and uses that to link to "[Medical Record #].doc" so that when a patient's Medical Record # is entered as 0001, the hyperlink will open "0001.doc" and so forth

will i have to use code builder to DoCmd a copy object?
or can i use some sort of simplified language in the Hyperlink Address properties (ie: [Medical Record #].doc)?

your help is greatly valued and appreciated!
cheers
richard

[mnemosyne]

ok i'll answer my own post for s&gigs
in case some googlers come round asking the same question...

I right clicked the text i wanted to use as a hyperlink, clicked Build Event... then Code Builder
then i entered this VBA code:

Private Sub Link_Label_Click()
Dim strfile As String
strfile = Me.controlname + ".doc"
Application.FollowHyperlink strfile
End Sub

good luck to all

[mnemosyne]

i just found this 9 years later after trying to remember how i did this 9 years ago...

@mnemosyne

[zmbd]

Nice to have that information available.
In fact, I just did the same thing here, I posted an answer a while back (has it been that long - yikes!) and ran into a similar issue and couldn't remember how I had solved it, nor find my notes... but I did remember I had posted here... and there it was! Bytes has been a real time saver and education!