Error Catching

[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.

 

[Ken Snell]

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

 

[dank57]

Are you looking to catch code error or data input error?

email me because I may not check back.