Open PDF file

[shann]

hello there ive got this code in opening a pdf file

Application.FollowHyperlink "A:\AccessDatabases\Zoning\ZoningArchived\" & "2017-04-25-01-MARCELO-DELPILAR.pdf"

it works fine, however when i replace it with

  Application.FollowHyperlink "A:\AccessDatabases\Zoning\ZoningArchived\" &  me.myFileLocationandName

It gives me error saying cannot open the file specified.. i just replace the string,, i have same value as well.


Please guide me.

[June7]

This code is in a form event and myFileLocationandName is a field of the form RecordSource?

[shann]

yes sir .. its in a form triggered by a button.
myFileLocationandName is a textbox having the string location "A:\AccessDatabases\Zoning\ZoningArchived" & "2017-04-25-01-MARCELO-DELPILAR.pdf"

[June7]

Okay, and the textbox is bound to a field of the same name?

I cannot replicate the issue. Code works for me.

Could there be permission issues for that folder?