How do I create a hyperlink to an intranet file that varies based.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database used to track an interview process. Part of an
Access form needs to contain a link to a resume in a .doc or .pdf file. The
link needs to refer to a file on the company network. The path name varies
based on values populated in a combo box. I can create a hyperlink, but
don't know how to create a path name that varies based on a value in a combo
box.
 
You could concatenate the values together to get the path, ie

strPath = Me!ComboBox & "\MyDocument.Doc"
 
Back
Top