Follow hyperlink opens then dissappears behind access

[Costefran]

Can anyone help

I have a control called [Hyperlink] on my form that is set to IsHyperlink and works fine. When the curser is above the control it changes to a hand and when I click I use a follow hyperlink event (on click) to open the associated document / URL etc.

This works fine, the document opens but then dissappears behind access so its not the end of the world but not great for the user who then has to bring the open document to the front of access
If I place the hyperlink in a label as a hyperlink address the associated document / URL is opened and placed in front of access

I would like to be able to do this via the control and not the label so is there anyway I can force the opened document to the front of access and any other applications that are open

Thanks

 

[kjv1611]

You might could look at messing with the Shell object in order to set the focus to the new Window once it's open. You'll want to make sure that if the file/URL could be different on different occasions that you code for that with variable(s) as well.

--

"If to err is human, then I must be some kind of human!" -Me