Deletion events - what order do they occur?

[Baby Face Lee]

Hi guys
Assuming that a user confirms that they want to delete the selected record,
does the AfterDelConfirm event occur prior to the Form AfterUpdate event or
is AfterUpdate not called when records are deleted?
Thanks!

Lee

 

[Allen Browne]

In an MDB, the events fire in this order:
Delete
BeforeDelConfirm
AfterDelConfirm

I would not expect Form_AfterUpdate to fire, though Form_Current will.

Internally, I believe that Access wraps the deletion in a transaction, and
the Status argument of AfterDelConfirm indicates if the transaction is
committed or rolled back.

If you are using an ADP instead of an MDB, the order is different:
http://support.microsoft.com/kb/234866/en-us

 

[Baby Face Lee]

Thanks for the quick response Allen.
Much appreciated.
Lee