You must use the BeforeUpdate event of the *form* to trap the saving of the
new record. There are so many ways a record can be saved, e.g. closing the
form, tabbing past the last control, applying a filter or sort or
reassigning recordsource, Shift+Enter, closing Access, Save Record from the
Records menu, etc, etc.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.