How To Activate Control by Clicking Other Control

  • Thread starter Thread starter Mike Boozer
  • Start date Start date
M

Mike Boozer

I am inserting pdf documents into records. Rather than having to deal with
the bound control box (which shows icon and filename), I would like to
simply create a button that activates it. I currently have a button
(acCmdInsetHyperlink) that inserts a link into a field called ScanLink. This
is cool but user now sees path link and long file name in the ScanLink
field. Any way to hide the ScanLink field and design a button (with a nice
graphic of course) that would activate the ScanLink Field? In my example,
the button ViewDoc would work like this:

ViewDoc_OnClick
Me.ScanLink.Setfocus
Me.Scanlink.Activate (or Open or Click-Need Syntax)

Basically need correct syntax for the above code. Thanks
 
Got It! Weeehaaaa!

DoCmd.GoToControl "MSDSScanLink"

MSDSScanLink.Hyperlink.Follow



Thanks.
 
Back
Top