Error when using followhyperlink me.path

[tontenn]

Hi Remou and Team Im back with a continuing question in regard to this issue.Refer to thread thread181-27567

I have now created a new table and a new form within the database above and wished to do the same thing, click on the path to take me to the form on our server.

Followed all instructions as before and in the click event pasted the code

Private Sub Path_Click()
FollowHyperlink Me.Path

End Sub

When I go back to the form and test it the first record in the form with a path like this "\\Csc-server\Common\CSC\STANDARD\CSC - IMS\Section 3 - Forms\" goes straight to the folder. Which is exactly what I want.

But every other path in the form, and ill give you one as an example "\\Csc-server\common\CSC\STANDARD\CSC - IMS\Section 3 - Forms\Plant & Equip Service Report.doc", fails to load and comes up with an error

"Runtime Error 490" Cant open the specified file. and then when i press debug it just highlights in yellow "FollowHyperlink Me.Path".

Its really strange and cant work out why it worked perfectly for all the previous forms and the first record in this form and then not for anything else.

I hope you or someone can help.

Regards

tones