See Attached - One table and one continuous form .
The "CustomerCode" is the unique identifier of of the table.
Therefore if I set up a NEW customer with a code that ALREADY exists I will get a nasty message when I try to exit from the record. "The Changes you requested to the table were not not successful because they would create duplicate values .... etc"
How can I give a more elegant response to the users error. ?
This error does not seem to respond to normal VBA error handling.