O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required