How do I write code to interact with a hyperlink?

[OhioSteve]

I have a hyperlink on my form called myLink. At times I will need to click that hyperlink using VBA code. I know that sounds crazy, but trust me I need to do this. So I need to write something like:

forms!form1!myLink.click

But I suspect that that is not exactly right. Does anyone know the exact syntax?

 

[Blorf]

Hi.

Have you tried FollowHyperlink?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[OhioSteve]

Okay, I tried this:

Forms![startup1]![myLink].followhyperlink

I got the error "object does not support this property or method".

 

[OhioSteve]

Oh! I get it now. "FollowHyperlink" is a static method.

followHyperlink("

http://www.cnn.com")

 

[PHV]

Why not simply call the Follow method of your form's Hyperlink object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886