News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Sunday, December 21, 2008

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.

Labels: ,


Post a Comment

<< Home