Events on query datasheet

One more interesting sample by Krzysztof Naworyta, Access MVP - lightweight form events. Imagine that you open a select query and want to run some code on Unload or AfterUpdate event. Looks like Access does not offer such opportunity, but it is! Using Screen.ActiveDatasheet you can get a reference to query’s form object and then work with it as normal Access form. Same applies to tables/queries as subfoms. Run the sample and look at VBA code to learn this technique.