Create an unbound list box, drop-down list box, or combo box that displays values from a table or query

1. Open a form in Design view or a data access page in Design view.
   
   
2. Make sure that the Control Wizards tool is pressed in the toolbox.

   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 , the Dropdown List tool , or the Combo Box tool in the toolbox.
   
   
4. On the form or data access page, click where you want to place the list box, drop-down list box, or combo box.
   
   
5. Follow the instructions in the wizard dialog boxes. When the wizard asks how you want to get the values for the list, select the option that says you want to look up values in a table or query. When the wizard asks whether you want to store the value or remember it for later use, select the option that says you'll remember it for later use.

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 .
  
  
• When you use a wizard to create a list box or combo box based on a table or query in a form, Microsoft Access creates an SQL statement based on the fields you select and sets the RowSource property for the control to that SQL statement. If the list box or combo box isn't sorted the way that you want, you can modify the SQL statement by clicking the Build button next to the RowSource property. For information on specifying a sort order in the SQL Statement Builder, click .
  
  
• When you use a wizard to create a drop-down list box based on a table or query in a data access page, Access sets the ListRowSource property to the table you specified in the wizard. If the drop-down list box isn't sorted the way that you want, you can create a query with a new sort order and select the query in the ListRowSource property box.
  
  
• For information on troubleshooting list boxes, drop-down list boxes, and combo boxes, click .