Solved Open a file without moving the focus

[Sun_Force]

But you never checked moving focus to the current form AFTER the FollowHyperlink????

I did and I explained it in #3 post on first page.
object.SetFocus in vba acts within the application. When OS has moved the focus to a different window (another application), no matter how many times you change the focus within Access, OS is focused on another application. The active window is newly opened document and not Access. So all key strocks etc goes to that application and not Access.You can test it for yourself and you'll understand what I mean. @arnelgp 's solution works and it makes Access the active window.

 

[Isaac]

you might have mentioned it earlier.

They did, in post 16.

The only reason I kept going with AppActivate is because when you can do with one line of code that you understand and can maintain instead of 200 that you don't and cannot, that should always be encouraged.