Hyperlink Focus

[Dave]

Hello,

I am using the following code, but would like to set the focus to
whatever the file is (excel/word etc)
after completion. The focus remains in the form in Access

Private Sub File1_Click()
Application.FollowHyperlink Me.File1, , True
End Sub

 

[Arvin Meyer [MVP]]

Try using a command button with the following code, instead:

Private Sub cmdHyperlink_Click()
Me.cmdHyperlink.HyperlinkAddress = Me.File1
End Sub

It should leave the focus in the called document.

 

[Dave]

Thanks - works a treat

Try using a command button with the following code, instead:

Private Sub cmdHyperlink_Click()
Me.cmdHyperlink.HyperlinkAddress = Me.File1
End Sub

It should leave the focus in the called document.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com