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..