Access: Reading deleted record buffer
Posted
by Michael Itzoe
on Stack Overflow
See other posts from Stack Overflow
or by Michael Itzoe
Published on 2010-03-26T19:43:57Z
Indexed on
2010/03/26
20:23 UTC
Read the original article
Hit count: 334
According to the Access (2003) documentation, when you delete a record, it's placed in a buffer, then the BeforeDeleteConfirm event is raised, then the AfterConfirmDelete ad Delete events. In my table if a record is deleted, I need to add one of its field values (a quantity value) to a field in another table.
I tried setting the quantity to a private variable in the Current event, but as soon as I delete click delete, it looks like the Current event fires again and resets my variable.
How can I access the value of a field in a deleted record?
© Stack Overflow or respective owner