Microsoft® Office Access 2007 VBA

Chapter 10. Working with Forms

IN THIS CHAPTER

Opening and Closing Forms 131

The Form Module 135

Form and Control Properties 135

Form Events 137

Case Study: Adding to a Combo Box 138

Opening and Closing Forms

The first part of this book was devoted to building a foundation in the VBA language. This part shows you how to apply the foundation building blocks to create practical applications. This chapter deals with using VBA with your forms. If you’ve been developing Access applications, you are familiar with creating forms. Now we show you how to use VBA to automate them.

First, let’s take a look at opening and closing forms using VBA.

Opening a Form

We introduced you to the OpenForm method back in Chapter 2, “Using the Visual Basic Editor.” The ...