totn Access 2007 Combo Boxes

MS Access 2007: Bound column in combo box

This MSAccess tutorial explains how to set up the the table column that is bound to the combo box in Access 2007 (with screenshots and step-by-step instructions).

Bound Column property

This is now what our combo box looks like:

Microsoft Access

The next property to set on your combo box is the Bound Column property. In Access 2007, the Bound Column property indicates which column to bind to for the control.

If you'll remember, we specified that our combo box is bound to the CategoryID field in the Products table. The Bound Column property tells us which column in our combo box to bind to the CategoryID field.

Since our combo box displays first the CategoryID and next the CategoryName, we set this property to 1 (the position of CategoryID in our result set).

Microsoft Access

This would bind us to the first column in our combo box. You are not required to bind to the first column. If your combo box displays multiple columns in the drop-down, you can select any of the columns.