Access 2007 In Pictures

Employ the Lookup Wizard

What does the Lookup Wizard do?

The Lookup Wizard allows you to create a field where database users can choose from a list of things.

This list can come from a table or query, or list items can be specified manually.

  1. In the Field Name column, type:


    then press TAB.
  2. In the Data Type column, click the down arrow, then Lookup Wizard...