Opening a file from a text box

Y

Yak

How do I open a pdf file that is listed on my form in a text box. The file
is different for every record but must be able to be viewed in full. I dont
mind closing the adobe when finished viewing the file. Got any ideas?
 
A

Allen Browne

FollowHyperlink will open the program in whatever program is registered to
hand the file type.

Example, assuming the text box named Text0 has the file name but not path:

FollowHyperlink "C:\MyFolder\" & [Text0]
 
Top