k thanks June7
I now have these:
and still getting the same error but i cant figure where to catch it.
As a side note, it occurs when leaving the "required field" after an update,
however i have nothing in the events for this field
So it must be running off the form_update event, but it isnt getting caught?
Code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Select Case DataErr
Case 3314
MsgBox "This is from Form Error"
On Error Resume Next
Case Else
MsgBox "another error" & DataErr
On Error Resume Next
End Select
End Sub
Private Sub Form_BeforeUpdate(cancel As Integer)
Dim DataErr As Integer
Dim Response As Integer
Select Case DataErr
Case 3314
MsgBox "This Is from Form Before Update"
On Error Resume Next
Case Else
On Error Resume Next
End Select
End Sub