Avoid sql server error messages

[petermeachem]

If I try to add a duplicate record, I get a huge message box full of square brackets and gibberish, which the users dont like. Is there a better way of handling this than checking for duplicates in the key field after update event. This still doesn't work properly as the table, quite properly strongly objects to a blank primary.
I'll post this in the sql server forum too.