Hyperlink button linked to a combobox

[Tasslehoff]

I have a button that, when clicked upon, I would like to hyperlink to one folder--the location of which being specified by a value the user selects from a combobox.

Example of what I would like to happen:
1)The user selects the Ship Name "AGER 2-Pueblo" from the combobox list.
2)The user clicks the "Go To Ship Folder" button to go to this ship's folder.
3)Access takes "AGER 2-Pueblo" from the combobox and tacks it on the end of the general address of "C:\Documents and Settings\Desktop\Ship Stuff\" so that the folder "C:\Documents and Settings\Desktop\Ship Stuff\AGER 2-Pueblo" opens.

I tried searching for this...but found nothing except the application.followhyperlink code, which I can't get to do this. Can this be done? I would appreciate any help.

 

[ghudson]

Knowing what to search for is half the fun!

Is this possible [yes it is!]

Check this out... Browse [Find a directory or file]

HTH

 

[Tasslehoff]

Awesome to the max

Thanks! This works great--just like I wanted it to. I had searched for this answer for hours and could find nothing... I'm a little new to Access (I am a summer intern) and I have only just begun to explore VBA. This site has been very helpful to me in the past and I am glad my first post here got a great answer. Thanks again!

 

[ghudson]

Your welcome and a belated "welcome to the forum".