Default Error Message

[Nick]

I have a table, tbDetails with a primary key field,
MemberNo not allowing duplicetes. When users with little
access experience enter a duplicate member number and they
receive a system message explaining what they have done.
My question, is there any way of cancelling this message
and setting up my own?

Regards
Nick

 

[Ken Snell [MVP]]

Sounds as if you're entering data directly into the table. Do not do that!
Always use a form for data entry.

Tables give you no ability to run macros or VBA code; no ability to
"intercept" errors or error messages.

Forms give you such abilities, and it's there that you can provide your own
message for duplicate entries.

 

[Ed Robichaud]

Try using this in the OnError event of your data entry form:

Const conDuplicateKey = 3022
Dim strMsg As String

If DataErr = conDuplicateKey Then
Response = acDataErrContinue
strMsg = "Attempting to Add Course# and/or Title that already
exists. Change Course/Activity#."
MsgBox strMsg, vbExclamation, "Duplicate Record"
End If


-Ed