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