Deleteing duplicate records..

[gbanks]

I have a subform that allows the users to tuype in an item ID#.. The problem I have is when the inadvertently add the same ID# twice. I have a button on the sub form that will delete the current record when pressed. But when the user enters in a duplicate ID# it will not delete the duplicate record and it gives me an error box saying the changes were not succesful because they would create duplicate values in the primary table.. If the user enters in a bogus value they then can delete the record.. Is there a better way than this? Thanks..

[charlotte]

Put some code in to trap the duplicate key or index error and issue a Me.Undo to back out the new record when the error occurs. You aren't deleting the record because it has never been created--that's what the error means. Using an Undo method simply backs out whatever was entered in that record.