open word doc depending on combo box selection

GetReel

Registered User.
Local time
Today, 22:28
Joined
May 22, 2003
Messages
67
Im using a combo box and I want to open a word doc depending on what I have selected in my combo box. I did a quick search on the forum but didnt find anything.

e.g
Case Select

If Me.cboRegion.value = "West" then
Open word doc c:\letters\4weekletterWest.Doc

If Me.cboRegion.value = "North" then
open word doc c:\letters\4weekletterNorth.Doc

Can someone point me in the right direction.

thanks
 
Code:
Select Case Me.cboRegion
    Case Is = "West"
        Application.FollowHyperlink "C:\letters\4weekletterWest.Doc"
    Case Is = "North"
        Application.FollowHyperlink "C:\letters\4weekletterNorth.Doc"
    Case Else
        ' do nothing
End Select
 
Perfect! Thanks Milo
 

Users who are viewing this thread

Back
Top Bottom