Automatically reference records primary key in a hyperlink

[jbr87]

So I have a DB that is used to track jobs with the job # being the primary key in the following format 2001-45 for example 2001 being the year of the prject and 45 being the 45th job of that year. In the record I'd like to link to project documents like drawings and such.

Now the plan is to have all the jobs files store on a network drive with a standardized file path format eg \\pdserver\folder1\2001-45\drawings with the only changing variable being the job number (records primary key). Is it possible to have the hyperlink feild automatically point to the file address without the user manually searching through the file tree? Can the job number be a linked variable in the hyperlink address?

I tried putting this as my default value for the feild \\pdserver\folder1\[Job Number]\drawings but all I get is a -1 value in the field not thwe actual link

[boblarson]

This is how I would do it. I would NOT store the value as a hyperlink but instead use code in the click event of the control which displays the primary key to build the link:

Dim strLink As String
 
strLink = \\pdserver\folder1\ & Me.JobNo & "\drawings
FollowHyperlink strLink

Something like that.

[jbr87]

This is how I would do it. I would NOT store the value as a hyperlink but instead use code in the click event of the control which displays the primary key to build the link:

Dim strLink As String
 
strLink = \\pdserver\folder1\ & Me.JobNo & "\drawings
FollowHyperlink strLink

Something like that.

That was the solution I came up with as well, but I created a button in a form to do the same.

Not only does it do what I would like it to it saves space and eliminates user input errors.

thanks