form button launches variable folder location

[Zadok @ Port of Seattle]

I have a form/subform page.
On the form I have a button to 'Browse Folder' that I want to open
Explorer.exe and go to a folder location which is defined by a 'hyperlink'
field in my subform. I know how to run the shell command to get explorer to
launch, but getting that variable folder in the code is baffling me.
Make sense?

Many thanks,
Zadok @ Port of Seattle

 

[Allen Browne]

Try:
Application.FollowHyperlink "C:\Data\SomeFolder"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Zadok @ Port of Seattle" <[email protected]>
wrote in message
news:[email protected]...