That's the only way to catch it before the record is saved, regardless of
how that is triggered, e.g. closing the form, applying a filter, changing
the sort order, moving to another record, closing Access, reassigning
RecordSource, pressing Shift+Enter, saving through the menu, etc, etc.