Microsoft Access 2010 Bible

Part IV: Professional Database Development

984

FIGURE 28.6

The Auto List Members drop-down list makes it easy to select an object’s properties or methods.

Furthermore, if you position the input cursor anywhere within the property name (such as

ProductName) and press Shift+F2, the class module opens, showing you the code associated

with the property (see Figure 28.7).

FIGURE 28.7

Shift+F2 shows you the code associated with an object’s property.

The class module’s VBA code must be available for the Shift+F2 shortcut to work, of course. If the

class has been bundled as an .mde or .accde file or is otherwise unavailable, Shift+F2 will not

work.

Note
In case you’re wondering, the Shift+F2 shortcut works in any Access module, not just class modules.

Generally speaking, object-oriented programming techniques are most often applied to unbound

applications. Although you can build an Access application with a mix of bound, unbound, and

object-oriented techniques, using bound forms misses one of the main advantages of object-

oriented programming: control over how the data is used in the application. Most developers turn