Advanced Tables and Queries   «Prev  Next»
Lesson 2Combo Box and List Box controls
ObjectiveWork with controls that display data from other record sources.
The Combo Box and List Box controls are two of the most versatile controls available in Access.
They allow you to display and pick data from a lookup table and they allow you to display data from other tables without requiring joins in the underlying record source of the form or report on which they are used.
You got a taste of using the Combo Box and List Box controls as lookup fields in Module 2. You also saw how to use the Combo Box and List Box Wizards.
To use the wizards to place the controls on forms, you can drag and drop the controls from the toolbox by using either the Combo Box control button Combo Box control button or the List Box control button List Box control button.
I would like to take this opportunity to expand on that knowledge for you.

Important properties of Combo Box and List Box controls
The wizards do a good job of creating the controls that are needed to use simple Combo Box and List Box controls. To take advantage of some of the more advanced features, however, you will need to be comfortable with some of the properties of the Combo Box and List Box controls. You can see some of those properties in this MouseOver:
Combo Box List Box Properties
Using the properties pointed out by the MouseOver, you can display additional information on a form using a Combo Box or List Box control.
In the next lesson, you will learn how to use the Option Group Wizard to create an Option Group control.