Access shuts down on Error? How to stop this?

[cbjames]

I have an Access database screen that hyperlinks to documents stored in specific folders. If the hyperlink finds the document it open just find. But, If there is NOT a document there it throws an error (which is perfectly fine). However, after you click the error message to close, e database closes and you have to open it up all over again. Here is my 'very basic' code.
Private Sub cmdDocCharges_Click()
'
Application.FollowHyperlink "\\corp.heb.com\dfs\Distribution\Transportation\Inb oundLog\Public\Produce Supporting Docs\Carrier Rejection Charges" & DLookup("TripID", "qms_Truck_Issue_Email") & ".pdf"
'
Exit_cmdDocCharges_Click:
Exit Sub
Err_cmdDocCharges_Click:
MsgBox Err.Description


strMsg = "No documents for this TripID."
MsgBox strMsg
Resume Exit_cmdDocCharges_Click
'
End Sub


Any thoughts would be greatly appreciated. I am stumped.

[pbaldy]

It shouldn't happen with proper error handling:

http://www.baldyweb.com/ErrorTrap.htm

[cbjames]

I used the "On Error GoTo ErrorHandler"... and now everything works perfect. Thank you so much!!

[pbaldy]

Happy to help. You had part of it, but not the key part.

Welcome to the site by the way!