Opening specific Word file from Access

P

Peter

Let's say I have three Word documents:
doc1, doc2, doc3

I have a form wish a drop down list with these three doument names.
When the user chooses one of the three document names I want Access to
open the specific Word file with that name.

Any suggestions on how to do this?

Your help is greatly appreciated!
 
A

Albert D.Kallal

In the after update event of the combo box, you can use



application.FollowHyperlink (me.mycomboname)

And, of course, those names in the combo box could be excel, word, or
pdf...it really don't matter...
 
D

Douglas J Steele

Albert D.Kallal said:
In the after update event of the combo box, you can use



application.FollowHyperlink (me.mycomboname)
Click to expand...

Of course, whatever's passed from me.mycomboname will have to include the
complete path to the file.

If it doesn't, you'll need to add the rest of the path:

application.FollowHyperlink ("C:\Documents\" & me.mycomboname)
 
Top