Error Handling: Ignore Access Error

[Myriad_Rocker]

I have sucessfully put some code into the On Error event on a form...it does what it is supposed to. But I don't want the generic Access error to pop up right after my message box tells the user what is wrong. I've search the forum to no avail. I was hoping for some help.

My Code for On Error on my Form:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    If DataErr = 3058 Then
        MsgBox "Some or all required fields are blank!", vbCritical, "Error"
    End If
End Sub

Like I said, this works fine. It pops up and then the generic Access error for 3058 pops up as well...I don't want that one.

 

[pbaldy]

Try adding:

Response = acDataErrContinue

 

[Myriad_Rocker]

Try adding:

Response = acDataErrContinue

Perfect! Thanks much!