F. Scott Barker's Microsoft® Access 2000 Power Programming

TAPPING INTO THE POWER OF COMBO BOXES

Using combo boxes is fairly straightforward when you use them just to look up and display one item of data from another table. Access also includes a Combo Box Wizard that makes creating combo boxes even easier.

Using the Combo Box Wizard

Because the Combo Box Wizard is powerful and helps create a rather complex control, it's covered here—unlike most of the other wizards that would be presented in a lower-end book. You'll walk through how to use the Combo Box Wizard to create a combo box that performs the following tasks:

• Allows users to look for a record on the current form and display one field while searching on another value

• Performs a lookup and updates the foreign key in the current record while displaying ...