>>How could I prevent the error message "...Uniqueness Voilated..."
>>while updating record into a table.
>>Anyway to handle/prevent? I would like to control this error message
>>with the MESSAGEBOX() function. How to detect this error? Thanks.
>
>I guess, the source of message is some candidate or primary index. If you want to trap it, use standard 'ON ERROR do something' approach (AERROR works good here).

I had a similiar problem, and unfortunately worked around it to get the system on the floor by making the index
regular from primary. I found primary indexes weren't checked until the user tried to save the record
and then it bombed the system.

This now allows dups, and I thought I could solve it with some code in the error event. I wrote the code,
and it, too, messes up the dataentry process. I put it in the valid event for the text field but it just errors
out the whole record rather than allowing the user another chance.

Any general comments would be greatly appreciated.