Microsoft® Access® 2010 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 continually over and over in a repeated loop. For example, suppose that you created data macro logic attached to the After 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 After Update again because data in the table changed. The After 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 After Update event. Access could also get into a loop, ...