Richard - I know how to link to a specified document as in #file://folder/file.doc# What I want to know is whether or not I can 'calculate' the path to hyperlink to using concatenated field values. I have fields called [Provider_Name] and [PRCODE] and I want to hyperlink to a folder which is a combination of those two values in each case. How do I specify the fieldnames in the hyperlink spec? I tried using the following:
That doesn't work, obviously
Thanks - that's a help, but I'm not quite there. I'm unclear as to what you mean by "#file://folder"
How do they relate to the constants M:\Providers ?
how do I specify it if I just want the hyperlink text to be the word Files and the address to be M:\[Provider_name] [PRCode]
Should it be
"#fM:\" & [Provider_Name]&" "&[PRcode] & "#"