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