On Change fires each time you change control data and that means with every keypress so you don't want that. You can update a form via several methods: leave the record, close the form, code for several events (after update, exit, lost focus to name a few). Really depends on the situation but Me.Dirty = False will save changes provided there are no rule violations.
Last edited by Micron; 05-16-2018 at 10:30 AM.
Reason: Stoopud auto korekt!
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.