Sorry, I should have explained.

The PK is made up of 2 fields, the second one is being input by the user, I just wanted a warning message to occur if they entered something in the field that is already being used, and let them change.

I have decided to use record validation and a stored procedure.

Thanks
Kev