I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contractReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10296-followhyperlink-question.html
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
Private Sub Toggle1_Click()
Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndNameReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296
I am not too good with code, so I am hoping it is an easy fix.