Hyperlinks

M

Matt

I have designed some code to make a folder based on 2 field values and then
place the address of the folder location into a hyperlink field. I have
placed the code behind a button in a form. The code creates to folder no
problem but I can not get the hyperlink field to store the location of the
folder. Can anyone tell me what I am doing wrong.

MyFolder = Me![txtJobNo] & "_" & Me.txtCustomerName]
MyPath = "\\server\LossFiles"
MkDir MyPath & "\" & MyFolder
---work to here
MyHyper = MyPath & "\" & MyFolder
Me.hypPath = HyperlinkPart(MyFolder, acDisplayText)
Me.hypPath = HyperlinkPart(MyHyper, acAddress)

I can get the hyperlink field to display text and not to hold the folder
location. This is driving me mad

Thanks Inadvance

Matt
 
Top