Opening specific Word file from Access

[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!

 

[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...

 

[Douglas J Steele]

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



application.FollowHyperlink (me.mycomboname)

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)

 

[Peter]

Thanks so much for the help. It is always simle if you know what you
are doing .