Create a bound list box, combo box, or drop-down list box that retrieves data from a table or query in a Microsoft Access project or a data access page

1. Create a new form, report, or data access page based on a record source that includes a foreign key field.
   
   
2. In the toolbox, make sure the Control Wizards tool is pressed in.

   Note   Wizards are not available in a stand-alone data access page, or when you point a data access page to a database other than the one currently open. In both cases, you will have to create the list box or drop-down list box on your own.

3. Click the List Box tool , Combo Box tool , or Dropdown List tool, and then click where you want to place the control on the form, report, or data access page.
   
   
4. Follow the instructions in the wizard dialog boxes. When the wizard asks you how you want to get the values for the list, select the option that says you want to look up the values in a table or query.
   
   
5. In a form or report, when the wizard asks if you want to store the value in the field, select the option to store the value in the field and select the field from the list.
   
   
6. In the last wizard dialog box, click Finish.
   
   
7. In a data access page, click Properties on the toolbar to open the property sheet for the control. In the ControlSource property box, select the field to bind the list box or the drop-down list box to.

Notes

• For information on properties that determine how a list box or combo box works in a form, click .
  
  
• For information on properties that determine how a list box or drop-down list box works in a data access page, click .