Code:

StrInput = Me.SearchListbox.Column(1)
    Application.FollowHyperlink StrInput, , True

This works great, but if the file path does not exsit it gives me and error code how can I msg box my own message when file path is not found?

---

Reply from Richard Rost:

Basic error handling:

Sub MySub
On Error Goto MyErrorMessage
'your code here
exit sub
MyErrorMessage:
msgbox "you messed up!"
End Sub

I just searched my index and it looks like I didn't cover this in any of my Access or VB6 classes. Must include a lesson on error handling in the upcoming Developer series!