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.
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 ...