i tried it. doesn't seem to work.
this is the coding i used.
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If Err.Number = 3051 Then MsgBox "That account number is already used. Try another account number.", 0, "Duplicate"
End Sub
did i put it in the wrong place?
ALSO. where can i find a list of error messages adn their numbers?