Hello All,
I'm trying to build out a hyperlink by concatenating a base hyperlink with a UID stored in a field. I assign the following code to a small symbol so it doesn't take up a ton of space on my report.
Code:
Private Sub link_Click()
'On Error GoTo err_link ** Commented this out because it was going to error message every time
txtURL = "http://ecos.fws.gov/speciesProfile/profile/speciesProfile.action?spcode=" & Me.ECOScode
DoCmd.Hourglass True
FollowHyperlink txtURL
DoCmd.Hourglass False
'Exit Sub
'err_link:
' DoCmd.Hourglass False
' MsgBox ("Sorry, there isn't currently a species profile for " & CommonName & "."), vbOKOnly, "Warning!"
End Sub
I'm getting error message 2465: MS Access can't find the field 'ECOScode' referred to in your expression, but it's there!