Access 2002 Programming by Example

Creating a Command Button

With the exception of the Before Update and After Update events, the command button has basically the same events as the other controls. The On Click event is probably the most commonly used event on this button. Clicking this button triggers an action, which could be in the form of a macro or a module.

Printing a Record

A common request of users is to print the current record on a form. Although Access has never added this feature, it is not difficult to produce this feature using a procedure. The following steps will guide you through the process of creating a button to print the current record:

1.	Open the Music Store database from the AccessByExample folder. Under Objects, click Forms to view a list of forms. ...