hyperlinks from a field value

[jdbirder]

Hi everyone,
I have a number field displayed in a form that I want to use to go to a web site based on the value in that field for that specific record. For example if the number in the field for a particular record is 12044675 then I want to hyperlink to an address like
http://www.ncbi.nlm.nih.gov:80/12044675=Abstract
I can't see how it's done, any ideas greatly appreciated

 

[Tim K.]

Add a command button and put this code to it.

Private Sub Command0_Click()
FollowHyperlink "http://www.ncbi.nlm.nih.gov:80/" & _
    Me.YourTextBoxNameHere & "=Abstract"
End Sub

 

[jdbirder]

thanks Tim,
that code works a treat.
John