Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Case Example

Earlier in this chapter, you learned how to automate actions by using macros. In this example, you'll use a macro group to help you create command buttons that open sets of records in a form. Specifically, you'll create buttons on an orders form to filter for regular delivery and overnight orders. This exercise also exposes you to creating and using command buttons. I haven't discussed command buttons separately, but (as you'll see) you shouldn't have any trouble figuring them out on your own.

First, let's create the macro group:

1.	In the Database window, click the Macros tab and click New.
2.	Choose View, Macro Names. The Macro Names column is displayed. You toggle the Macro Names column on and off by choosing View, Macro Names. ...