Entering Data in a Form by Using VBA

As you might suspect 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 17 different events; a form recognizes more than 50.


The events recognized by an object are listed on the Event tab in the object’s Property Sheet pane.

While you use a form, objects are signaling events, or firing events, almost constantly. ...

Get 2007 Microsoft® Office System Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.