Creating a hyperlink in a able from form information

R

rc51wv

In my form, One of the fields is txtBrowseResult which contain the file
location and name of a variable that needs to be inserted into a table then
hyperlinked.

Ex: txtBrowseResult = Z:\folder1\file.xls

txtBrowseResult needs to be inserted into the Link field of the
'tblResources' table as a hyperlink. The field's property is set as
hyperlink, but when the path is inserted into the field, it's inserted as a
hyperlink with no link destination. How do I fix this so that the field is
inserted correctly.
 
Top