I have been doing a ton of searching on this issue and looks like its something I should be able to do but cant. I have a table linked to a form say 10 fields. Simple enough, the table has a primary key and its an autonumberd field. I'm trying to prevent incomplete records so on the close button of the form I have code to verify if the record is incomplete, that works. I then clear the incomplete record but I still end up with a blank record with the autonumber in it. I tried creating a delete query based of the ID number but that does not work. Is there a way to do this? should I just not worry about it because its just an autonumber so it should not cause a problem?
jon
jon