When are Access records actually deleted from table?
Posted on 2009-04-20
i added record navigation and operation buttons to my form, through the button wizard.
I had 5 test records in my database table.
I used the delete record button to delete the 5 test records.
Doing a test with the record navigation buttons, it appears that they are deleted since when i use the previous record and next record buttons, nothing shows up.
when i go to the actual table, however, i still see the records.
Also, i have a query on my form that queries records by salesman name.
This query still returns records, when in fact it shouldn't (since i deleted all records).
Again, when i look at at the table, the records are there. The record navigation buttons just dont see them once i hit delete.
Can anyone explain this and tell me what i need to do differently with the delete record button?