Command Button Help

[emailloni]

Hello All -
I just finished up three days of access training and I am in love! I can't believe all the wonderful things that one can accomplish in access.
I have a question that my instructor was unable to assist me with but I'm more than confident this can be done with writing some code.
I have created a form for data entry that pulls from multiple tables. My customer table has a hyperlink to a folder on our shared network for each customer. I can easily put this in the form as the link but want to make it cuter by just using a command button. I've tried using a macro but can't find one that will go to the Link entry and click it to take me to the folder. Can anyone help me??
Thank you so much!
Loni

[RuralGuy]

Are you looking for something like: expression.FollowHyperlink(Address, SubAddress, NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)

[emailloni]

Well....I'm not quite sure....this is what I have so far:
Private Sub Command17_Click()
Command17.HyperlinkAddress = [Link].Value
End Sub

Link is the filed that I have my hyperlink in.

And it looks like it wants to work but I must be missing something small, here is my error:

Microsoft Access cannot follow they hyperlink to '\\fhp-ww.com\filestore\location\chicago (hus1)\Finance\99 Shared\02 AR\True Value Company'

Thoughts anyone??

[RuralGuy]

How about:
Application.FollowHyperlink Me.Link, , True

[emailloni]

Same exact error.....

[RuralGuy]

Loni.
That hyperlink looks like it is on the Internet and so the browser is used and my browser returns the same error. It is pointing to fhp-ww.com.