Hyperlink Field

I would like to add links to PDFs that are on my network and I have never used a hyperlink field.

The PDF name is the same as a field in the DB (permit number) so is it possible to make the default value setting set to the path with the value of that field? For example:

Default value: P:\NetworkDrivePath\[permit number]

Thanks
David

instead of adding links, I would just use a form to display a button on the record and then use this code:



You could also have it in a double click event for a field.

Bob:

Entered text below and received a Run-time error 2465 - cannot find the field Permit Number - is this because there is a space in the field name?

Code entered:

Dim strPath As String
strPath = "O:\TRAFFIC\TRAFFIC\Permits\SpecialHaulingPermitDat abase" & Me![Permit Number]
FollowHyperlink strPath

Thanks
David

If you are looking for a control you should use the DOT and not the Bang.

& Me.[Permit Number]

If there is a text box on the form named Permit Number

And you might need a backslash here too:

strPath = "O:\TRAFFIC\TRAFFIC\Permits\SpecialHaulingPermitDat abase\" & Me.[Permit Number]

Now I get a run time error 490

What's the full text of the error message?

Run time error '490':

Cannot open teh specified file.

Ahh, perhaps we need to modify to this:

strPath = "O:\TRAFFIC\TRAFFIC\Permits\SpecialHaulingPermitDat abase\" & Me.[Permit Number] & ".pdf"