Open PDF

I am goign to try and explain my issue the best I can and hope that one of you has some advice.

I have a form full of text boxes that are populated based on a Combo Box selection.
A couple of the fields are Not Visable and house a PDF name and PDF path
What I am tryign to do is allow the user to hit a PDF button and bring up the PDF image, although there may be recrods without a PDF image. So I am trying to test for this.
I wrote a basic If THen statement that tests for the PDF image name. IF it is there then it says "Its there", if not it says it "Not there". This worked out fine, showing me that I can test for an image name.

BALLFIELD_PDF_NAME = PDf image name
BALLFIELD_PDF = PDF Image Path (location of image)

CODE:
Dim Test
Test = Me.BALLFIELD_PDF_NAME.Value

If Not Test = "" Then
MsgBox "Its there"
Else
MsgBox "Its not there"
Exit Sub
End If



I then wrote the below code to look for the image name, if there open the image, if not exit Sub.


Results:
When I open the form and all teh fields are blank adn try to open PDF from a record that I know does not have an image if get nothing (Exaclty what I want)(it exits the sub)
I then choose one that I know has an image and it opens the image (Exaclty what I want, open the image)
I then repeat on another that has an image and it opens that image. (Great)
My problem arises when I try and open one that does not have an image after opening one that does. It goes into the Else Statement (See below) but still opens the last image I opened.....
I cannot figure this out.....

Any thoughts




CODE:
Dim Test
Test = Me.BALLFIELD_PDF_NAME.Value

If Not Test = "" Then

MsgBox BALLFIELD_PDF

Command178.HyperlinkAddress = Me.BALLFIELD_PDF.Value
Else

Exit Sub
End If