Form_Error

[XFan]

Hi folks!

I have a question about the Form_Error sub... I need to do some error handling and this sub just doesnt work.... It never ever pass inside even when some errors are thrown... Anyone has a clue why? :banghead:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    MsgBox "inside error"
    If DataErr = 2169 Then
        Response = acDataErrContinue
    End If
End Sub

Just in case some people ask for it but I dont think it'll help alot!

Thanks alot for the help

XF

 

[XFan]

Ya k it's because [from Microsoft] This includes Microsoft Access database engine errors, but not run-time errors in Visual Basic or errors from ADO.

I just don't understand why some people give this as an example and everyone seems to say it works while it doesnt.. uh uh.