I'm using Access 2003 on a 2000 database. Under the DELETE button on a form, I use
to delete the record showing in the form. However, what actually happens is that the record being deleted is blanked out, and a new auto-ID value is assigned. This new empty record then stays as part of the table. In the ComboBox that I use to select the record (on the parent form), the deleted record then appears as "#deleted".
Even if I exit the database and restart it, the empty record is still there. After the restart, the record just now appears as a blank line in the ComboBox. To get rid of it, I have to do something like highlight the empty record at the normal database interface, and hit DEL, or select DeleteRecord from the EDIT menu. After that, the record is truly gone.
Can anyone explain why the record doesn't actually get *really* deleted? And how can I make it truly go away in VBA? Other solutions for deleting the record would be welcome, but I would also like to understand why this happens.