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

Get Beginning Access™ 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial