Microsoft® Office Access™ 2007 Plain & Simple

Running a Macro When a Form Opens

The best form designs put as much data as possible on the page, but it’s also important that the data be readable. After all, if you cram every field together on a form, you might as well display the data as a datasheet! One way to give you and your colleagues information about how a form works without taking up any of your form’s "real estate" is to display a message box when the form opens. By having the message box appear at the start, you ensure that your message is seen without getting in the way of the data on the form.

Run a Macro When a Form Opens

1. Open a form in Design view.

2. Double-click the form selector. ...