Writing user friendly error message in Access for specific SQL Server table error

[bv]

Hello,
I have several forms using data stored in SQL Server tables. When a user
enters duplicate information, I get the Access error message that says
(correctly) "The changes you requested to the table were not successful
because they would create duplicate values...etc.". I would like this
message to say "The contact information you entered already exists. Please
choose this contact from the contact list and add or modify information as
needed."

I am not using OnError to do this because if there is another problem that
causes an error message to occur, I don't want the duplicate contact message
to be shown.

So... is there a way to specify a message for a specific error type? And if
so, can I have the "real" error message show up when any other error occurs?

Thanks!
Beth

 

[Guest]

Look at this link on "Preventing Duplicates from being entered"

http://www.databasedev.co.uk/duplicates.html