Opening a pdf file from a button command

[Sym]

I would like to open a PDF document using a button control on a form to a file path listed in a field on the form (Me.Link). I am trying to use the followHyperlink code but I keep getting the runtime 490 error.

This is the code im using:
Dim strFilePath As String

strFilePath = Me.Link

Application.FollowHyperlink (strFilePath)

If I put a filepath to one of the pdf documents in the place of (strFilePath) it opens that pdf document fine but not when I declare a filepath based on the one listed on the form.

any ideas on how to fix this?

thanks

thanks

 

[Isskint]

Is Me.Link the full file path or just the document name?

 

[Sym]

its the full filepath. infact if I copy whats in that field and paste it where strFilePath is it opens the file no problem but if I leave it as is I get the security pop up and the 490 error. the filepath listed in the warning is exactly what the file path is supposed to be so im not sure why im getting this error

 

[Sym]

also if I copy and paste the filepath in the "link" field where me.link is in the code it works fine too. something wrong with the declaration of the variable I think

 

[Isskint]

Could you capture the file path and post it - exactly as it displays?

 

[spikepl]

Drop the brackets

 

[Sym]

Drop the brackets

Tried that, same problem. also tried [], "()" and various others with no better result.

 

[Sym]

Could you capture the file path and post it - exactly as it displays?

"X:\DOCUMENT CONTROL\01 MSP SYSTEM PROCEDURES\MSP 10 - Control.pdf"

 

[Sym]

figured it out, some of the records had " before and after the filepath which made duplicate " which is why it wasn't working.