Default Error Message

[Nick]

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

Regards
Nick

 

[Allen Browne]

Use the Error event of the form.