O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Building Interactive Form

Chapter 5 covered the basics of using ADO and SQL to work with data sources and showed you how to display the data retrieved from the database on a form. In this chapter, you will explore ways to build interactive forms and to control the operation of those forms programmatically using VBA code. Many of the topics covered in this chapter are illustrated in various examples throughout the book, but some also deserve a separate discussion.

The chapter will cover:

  • Navigating between forms

  • Opening, closing, and hiding forms

  • Choosing the right type of control to use for data

  • Populating controls

  • Displaying messages to the user

  • Validating data entered into controls

  • Setting control alignment and tab stops

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required