Hyperlink on a form

[Guest]

Hi,

I have a form field that contains a hyperlink. I would like to create just a
command button that will take the user to the site listed in the hyperlink
field, which changes with each record, without actually showing the
hyperlink field. How can I do this?

Thanx,

Ripper

 

[Roger Carlson]

Assuming you have a textbox on the form called txtHyperlink, do the
following:

1) Set the Visible property of the textbox to No.
2) Add the following code to the command button:
Application.FollowHyperlink Me.txtHyperlink, , True

That's about it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thank you. I've done as you suggest and upon clicking the button I get a

"compile error: argument not optional"

and .FollowHyperlink is highlighted.

How can I correct this?

Thanx!

 

[Roger Carlson]

What exactly is in the code. (cut and paste it)

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L