totn Access 2007 Combo Boxes

MS Access 2007: Form without combo box

This MSAccess tutorial explains how to start with a new form before a combo box has been added in Access 2007 (with screenshots and step-by-step instructions).

Setting up Form

For the purposes of this tutorial, let's look at how to create and configure a combo box object in Access 2007.

We've created a form called frmProducts that displays Product ID and Product Name. See picture below.

Microsoft Access

We've set the form's Record Source property to Products which means that the form will display records from the Products table.

Microsoft Access