Set Hyperlink from VBA Command Button

[ppkgoldengun]

All,

Searched the archives but no joy. Anyway I have a command button that executes the following code (basically picking a file and location and assigning it to the txtDocLocation fiedl).

Me![txtDocLocation] = GetOpenFile_CLT("C:\", "Select Document Location")
Me![txtDocLocation] = LCase(Me![txtDocLocation])

The txtDocLocation field has been defined in the table. Based upon my review of hyperlinks I think I need to set multiple values. What is the code that would set these values so that when you double clicked on the txtDocLocation field the file (word, excel, etc.) will open?

Many thanks for the help.

 

[ppkgoldengun]

GOt it to work using the follow hyperlink method. Thanks