Business solutions Automating Microsoft

10. Working with Forms

IN THIS CHAPTER

Opening and Closing Forms

The Form Module and Event Handling

Performing Common Tasks

Handling Errors at the Form Level

Working with Multiple Form Instances

Opening and Closing Forms

In the first part of this book, you learned the basics of the VBA language. Now it’s time to start applying your skills to Access. This chapter covers the use of VBA with one of the most commonly used Access objects: the form. You’re no doubt familiar with Access forms from developing applications. As a first step, you learn how to open and close forms using VBA.

Opening a Form

You already saw the code to open a form in Chapter 8’s case study. But it’s worth reviewing again, to make sure you understand what’s going on. ...