Microsoft® Access® 2010 VBA Programming Inside Out

Chapter 4. Applying the Access Object Model

• The Application Object Methods and Properties

• The CurrentProject and CurrentData Objects

• The DoCmd Object

• Manipulating the Forms and Reports Collections

• Using the Screen Object

• Enhancing the User Interface

It helps to think of Microsoft Access as being an object that contains other objects and collections of objects. When you open a form in the application, each control on the form is an object that is contained in a controls collection for that form object. The open form is contained in the Forms collection of the Application object (until you close the form). The Forms and Reports collections are very important for programming Access and contain open forms or reports.

If you want to look at all forms in an ...