What you can do is put this code behind your textbox OnClick event:....and another questions (very sorry). I cannot seem to use a textbox_click event to make the filepath's textbox into a clickable link to open the document.
now, replace 'txtbox' with the name of the actual textbox that holds the whole filepath to your desired file. This should treat the file path as a hyperlink and follow it (open it).Application.FollowHyperlink Me.txtbox, ,True