Hyperlink created on table via form

S

Sade

Hello all,

I'm trying to create a hyperlink to a Word document on the table itself, not
the form that is being used to populate the table. I can get it to work if I
set the form's field to hyperlink = yes, and I type in the exact address.
The problem is, I'm creating this for someone who is computer challenged, and
I don't want them to have to type the address in every time.

I've tried creating a second locked and hyperlinked field within the form
that takes the data input from the user, [Name], and makes it into an address
(C:\[Name].doc). This seems to work in that it populates the field with what
I want and it appears to be a hyperlink (the pointy finger comes up and
everything), but it only populates the "text to display" within the
hyperlink, not the actual file location.

I'm confused why when I type it in directly, it treats it as the address for
the Word document, but when I use code to populate the form's field with the
exact same address, it only treats it as "text to display".

Please give me some insight as to what I'm doing wrong, or if there is a
better way to do this.

Thanx
 
Top