In the previous two chapters, you learned how to design and build client and web forms that work with data from a single table, and you saw how to display data from another table by using a combo box or a list box. You also learned various techniques to enhance the appearance of your forms, and you explored control and form properties you can set to specify how a form looks and works.
In this chapter, you’ll learn how to design client and web forms that consolidate information from multiple tables. You’ll find out how to
Create a form based on a query that joins multiple tables
Embed a subform in a main form so that you can work with related data from two tables or queries at the same time
Use an option group to display and edit information
Define conditional formatting of a control based on the data values in the form
Use the tab control to handle multiple subforms within one area on a form
Create a form that spreads many data fields across multiple pages
Design a client form in PivotTable or PivotChart view and embed a linked PivotChart form in another form
Use a Navigation Control to easily allow navigation between other forms and reports
Use a Web Browser Control to display a web page on a form
Note
The examples in this chapter are based on the tables and data in HousingDataCopy.accdb, ContactsDataCopy.accdb, and ContactsNavigation.accdb on the companion CD included with this book. These databases are copies of the data from the Housing Reservations, Conrad Systems Contacts, and Contacts Map application samples, respectively, and they contain the sample queries and forms used in this chapter. The results you see from the samples you build in this chapter might not exactly match what you see in this book if you have changed the sample data in the files. Also, all the screen images in this chapter were taken on a Windows 7 operating system with the Access color scheme set to Silver. Your results might look different if you are using a different operating system or a different theme.
