Hyperlink w/Variable Any help is appreciated

[CCW8]

Please, Any help is appreciatedThank You


I tried using code builder from the cmd button and I am getting an
error 13
Type Mismatch
in debug I get (hi-lighted)
Set cmdPEBFile = PEBNumberTextBox
here is my code:
Private Sub cmdPEBFile_Click()
Dim cmdPEBFile As CommandButton
Set cmdPEBFile = PEBNumberTextBox
With cmdPEBFile
.Visible = True
.HyperlinkAddress = "\\ServerName\ServerDrive\Databases\EPEB\" & [PEBNumberTextBox] & ".pdf"
End With
End Sub

[ajetrumpet]

ummm.....cmdPEBFile is dimmed as a BUTTON. and you're setting it to a TEXTBOX control? What did you think was going to happen, bud? =)

[CCW8]

I thought it would somehow relate the command button to the data in the text box so it could be added to the hyperlink string as the actual file name. I was given this from an example of someone else work in another database. This was how they made it work for them but they have been unable to explain why it will not work for me.