Automatic entry in Hyperlink field based on another field on the form

[trstorer]

I have successfully included a hyperlink field in a table which opens up a WordPerfect file.

The entry in the hyperlink field identifies the path, filename, and extension. The path will always remain the same as will the extension. The filename is the same as a previous field entry on the form.

Is there any way to automatically populate the hyperlink field based on the previous field to streamline data entry?

Example:
BillNo field = 02-001
Hyperlink field = f:/files/shared/wp8/02-001.wpd

Thank you for your help. This forum has been a great resource!

 

[alcifer]

I think your best bet is to use concatenation.
Set the hyperlink as a locked field and load the following to the after update event on the field [billno field]

me.hyperlink = "f:/files/shared/wp8/"& me.[billno field].text & ".wpd"

 

[trstorer]

Thank You ! That's exactly the "direction" I was thinking of going, but just didn't grasp the logistics of code and where to put it.

I did insert the # sign before and after the text to insert and it links just fine.

It seems to be working great. Thanks, again!