Macros what does updating do
After Update macros and event procedures for a form run only if you change the data in one or more controls in the record.
You can't use the Cancel Event action in an After Update macro to cancel the After Update event.
When you move to a different record, the Exit and Lost Focus events for the control occur, followed by the Current event for the record you moved to, and the Enter and Got Focus events for the first control in this record.
To run the After Update macro or event procedure without running the Exit and Lost Focus macros or event procedures, save the record by using the Save Record command on the Records menu.
Can someone imagine using Microsoft Excel without formulas? And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden.
When this happens, a bunch of questions immediately flash across your mind. Why doesn't this formula update its value automatically?