F. Scott Barker's Microsoft® Access 2000 Power Programming

LOOKING AT MACRO-TO-CODE CHANGES

Developers sometimes feel nervous about switching to code because they fear getting themselves into a complex world without all the commands they have available with macros. This is far from true.

Although getting into code can be confusing at first, switching to VBA not only gives you more flexibility, it gives you more control. Most macro commands are covered with the DoCmd object, described in the following section; others either have equivalent commands or aren't needed in code.

Using the DoCmd Object

In code, most of the macro actions can be performed using the DoCmd object. The actions are used as methods that can be called with arguments. Most of the arguments have intrinsic constants, which can be used ...