You must verify the uniqueness before trying to update.

Vlad

>In my table I have a unique index on employee nr.
>In my form if someone enter a duplicate emp. nr I get an error.
>How do I trapp that error and make it possible for the user to revert??
>
>No I have ignore or cancel on ignore the message uniqness off record voilated just repeat.
>On cancel my app goes down the drain.
>
>Best regards
>
>Per Simmersholm