Bind a column from a list box, drop-down list box, or combo box

1. Open a form in Design view, or a data access page in Design view.
   
   
2. Make sure the list box, drop-down list box, or combo box is selected, and then click Properties on the toolbar to open the property sheet for the control.
   
   
3. Do one of the following:

   On the form, in the BoundColumn property box of the list box or combo box, specify a number that corresponds to the placement of the column in the list box or combo box. For example, type 1 to bind the first column in the list box or combo box to the underlying field specified in the ControlSource property. Include hidden columns when you count columns.

   On the data access page, in the ListBoundField property box of the list box or drop-down list box, enter the name of the field that corresponds to the placement of the column in the list box or drop-down list box.

Notes

• In forms, you can specify the number of a hidden column in the BoundColumn property. For more information on hiding a column in a multiple-column list box or combo box, click .
  
  
• In forms, if you set the BoundColumn property to 0, Microsoft Access saves the list index instead of a value from one of the columns. This is useful if you want to store a sequence of numbers instead of the list value.
  
  
• For more information on the BoundColumn property, click .