Error Catching

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

Patrick Graham

I forget how to catch an error and display a customized
message.

I want to basically ask a question and on the yes no
response take an action.

Thanks ahead of time.
 
Which part do you need help doing? Trapping the error? Or displaying a
message that can be answered?

There are many ways to trap errors; the best approach depends upon the type
of error that you want to trap, as different approaches are better for
different errors.

Can you give us a bit more info?


A generic reply is this:


On Error GoTo Err_Sub
DoCmd.OpenForm "FormName"
Exit Sub

Err_Sub:
If vbNo = MsgBox("An error occurred. Retry?", vbQuestion + vbYesNo) Then
Exit Sub
Resume
 
Are you looking to catch code error or data input error?

email me because I may not check back.
 
Back
Top