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 avoid #Error in expressions

If you have a form with subform, last one has no records, and you have a textbox on a main form which calculates total – then you can get #Error as a result of your calculation.

You can simply avoid this using IsError() function, just make the expression like this:

=IIf(IsError([frmMySubform].[Form]![txtTotal]),0, [frmMySubform].[Form]![txtTotal])