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.

How to recognize what form's element you click in datasheet view

I like using datasheets as subforms, but Access does not offer datasheet-specific events and properties to automate it. Here 2 cool samples from Krzysztof Naworyta and Krzysztof Pozorek, Access MVPs from Poland, which help to make datasheet more friendly.

How to recognize what form's element you click in datasheet view: column, record selector and so on

New events in datasheet view and Which column I’ve just clicked

Both samples in Polish, but VBA still in English.