The tip on my site is specifically for that kind of situation. I think there's code there too (I haven't worked on my site for a while).
>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