totn Access 2010 Combo Boxes

MS Access 2010: Control Source for combo box

This MSAccess tutorial explains how to set up the Control Source for the combo box in Access 2010 (with screenshots and step-by-step instructions).

Control Source property

In our form, our combo box is currently Unbound and looks like this:

Microsoft Access

One of the most important items to configure in a combo box is the Control Source property in Access 2010.

If you remember, we set the Record Source for our form to the Orders table. Now we want to specify what field in the Orders table this combo box is bound to.

So we'll set the Control Source property to ShipVia which is a column in the Orders table.

Microsoft Access

Now, our combo box is bound to the ShipVia column from the Orders table and looks like this:

Microsoft Access