Hi, everybody!

I have a button called "Save" which the user clicks on after entering all the data in my form.

If the user adds a duplicate value, VB displays a message box:
Run-time error '524'
The changes you requested to the table were not sucessful because they would create duplicate values and so on ...
and the buttons End, Debug, etc...

The message avoid duplicate data, ok, but it can cause some problems...

How can I "capture" this error (524) and display a simple message, instead of the VB one, (which is going to scare my users :-O who don't understand English). They may get scared also if they click on the "Debug" button and get into the code ...

I pretty sure that solving this problem is a piece of cake for you, folks, but, I couldn't solve it so far.

Feel free to pull my legs :-), but, please help!

Thanks in advance,
Roselene


[This message has been edited by Roselene (edited 02-08-2000).]