Form Variable in Hyperlink

[russ0670]

Hi Guys,

This is going to sound really dumb but I taught myself to use access and so there are large chucks of simple processes I don't know and need to learn as I go so please excuse my thickness. If you could also post in laymen's terms that would be great.

I have a load of pdf files located in a folder on our shared drive (k:/edid/) that I need my DB to be able to link to. I need either a hyper link on a label or a button in my form that when clicks uses the data from field (EDIDREF) to complete the link.

so basically i need the hyper link to be k:/edid/45456.pdf with the number changed to whatever is in the EDIDREF field.

I have looked for ages and I cannot find anything to help.

Thanks in advance

[RuralGuy]

Are you talking about putting strings together with the concantenation character "&"?

[russ0670]

maybe, i don't know what that means.

I basically want to create a new text field merging text and a value from another field (or merging two fields). Or a text label in my form created by merging text with a field value (or two fields).

I have done something similar on my website and if this was PHP I would type this in the page source ("edidref" is the name of the field in the database).

c:/edid/{edidref}.pdf

[RuralGuy]

If 45456 was in the EDIDREF control then:
"k:/edid/" & Me.EDIDREF & ".pdf"
would yield "k:/edid/45456.pdf"
as a string.

[russ0670]

thanks perfect.

I knew it would be simple but i just cound not find the right syntax

rep+

[RuralGuy]

Glad we could help. Are you ready to follow the link in my sig and mark this thread as Solved?