Not sure exactly what you want, but maybe this will help. When editing a record (meaning the controls on a form are bound to a table or updatable query) events for controls happen first. When you do anything to update the form (commit the changes to a record) form events occur. The first, I think, is BeforeUpdate. Various user actions will cause the form to update - moving off the record, closing the form or any code that causes this to occur. You may see a new combo selection in a table if you look, but if you haven't committed the record, you'll see the pencil on the left side of the table row, which means that updates have not yet been committed.
So based on your comments I can't tell if you want to edit some field(s) in a record before you commit it or after that happens.
Last edited by Micron; 02-14-2020 at 08:42 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.