Hyperlink Focus

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
Back
Top