Microsoft Access 2013 Inside Out

Understanding recursion in data macros

When you’re designing data macros, you have the potential to run into a recursion issue. Access runs into a recursion issue when it tries to execute the same data macro logic over and over in a repeated loop. For example, suppose that you created data macro logic attached to the On Update event of a table that changed data in the current record of the same table. Access makes the field changes and then commits the data. Access then fires the On Update again because data in the table changed. The On Update event fires again, changes the data, and the cycle begins again. Access is now in a perpetual loop executing the data macro in the On Update event. Access could also get into a loop, for example, when working ...