Help with VB

"I need to create a hyper link dynamically (selecting a part of the hyperlink string from a field in the Access DB) within Access and put it on a form or report. What is the best approach for this??
So the steps are: select a field from a table and then concatenate a folder name (just a hardcoded string) with that (just retrieved) field. The result of the concatenation will be my hyperlink (looks something like this: "c:\test\bill.pdf"). And then this link will be shown in the form. When running it and clicking on it, it should popup the pdf

hope someone can help this is urgent!
Cheers

use the Ampersand to concantenate

Select TableFields from TableName where TableField = what you want

NameOfField=!TableField

FolderName = your hardcoded string

hyperlink = "c" & "\" & FolderName & "\" & NameOfField

txtText.text = hyperlink

You could also have the user scroll to location using a CommonDialogue
box thats in tool bar of VB

Hope this helps