Using Visual Basic for Applications to Enter Data in a Form

As you might have suspected by now, almost everything in Access, including the Access program itself, is an object. One of the characteristics of objects is that they can recognize and respond to events, which are essentially actions. Different objects recognize different events. The basic events, recognized by almost all objects, are Click, Double Click, Mouse Down, Mouse Move, and Mouse Up. Most objects recognize quite a few other events. A text control, for example, recognizes about 17 different events; a form recognizes more than 50.


You can see the list of events recognized by an object by looking at the Event tab on the object’s Properties dialog box.

While you use a form, objects ...

Get Microsoft® Office System Step by Step -- 2003 Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.