Application.followhyperlink opens adobe but closes as soon as open

[Regan via AccessMonster.com]

Hi

i have the following code to open a pdf file, it open and closes adobe in a
flash. i want it to keep adobe open
any ideas?

Private Sub LstPDF_DblClick(Cancel As Integer)

Dim strFileName As String
Dim strfile As String
Dim strFileNum As String

strFileName = Me!LstPDF.Column(0)
strFileNum = Me!txtFileNumber
strfile = "\\Richard\My Documents\VCS\VCS_Files\" & strFileNum & "\" &
strFileName
Debug.Print strfile
Application.FollowHyperlink strfile

End Sub

\\Richard\My Documents\VCS\VCS_Files\1218\DPS26012t.pdf <---Example of Full
Path

when double clicking on file in explore it opens fine
i've tried adding File: in strfile strfile="file:\\Richare\e.t.c
and i've looked at previous threads and haven't found a soultion
any help would be appreciated

Regan, Cheers

 

[Guest]

Had the same problem just about 2 weeks ago. Do the upgrade with Adobe and
it will be taken care of. its not an access problem

 

[Regan via AccessMonster.com]

Had the same problem just about 2 weeks ago. Do the upgrade with Adobe and
it will be taken care of. its not an access problem

Thanks BrainPaul

Just downloaded the update and it works fine now,

Thanks alot

Regan