Arthur Fuller
fuller.artful at gmail.com
Tue Aug 9 10:43:10 CDT 2011
I have always been wondering about this, and found this link. It might be useful to someone on the list. http://office.microsoft.com/en-us/access-help/order-of-events-for-database-objects-HP005186761.aspx It includes a tree that breaks down the type of event you want. Here's the tree. You'll probably have to visit the above to get the whole story, but this is a start: A single action, such as moving from one control to another, can trigger several different events, which occur in a particular sequence. Knowing when events occur and in what order they occur is important because it can affect how and when your macros or event procedures run. For example, if you have two event procedures that are to be run in a certain order, you want to make sure that the events they're associated with occur in that order. [image: Show]Order of events for controls on forms [image: Show]Order of events for records on forms [image: Show]Order of events for forms and subforms [image: Show]Order of events for keystrokes and mouse clicks [image: Show]Order of events for reports and report sections HTH, Arthur