How to Create an Access 2007 Combo Box

By eHow Computers Editor

Rate: (3 Ratings)

A combo box in Access 2007 provides a way of selecting a value from a list. This is quicker than remembering which value to type and ensures that the entered value is valid. A combo box is a compact method of presenting a list of choices and allows you to enter a value that is not in the list. Here's how to add a combo box in Access 2007.

Flag Article

Instructions

Difficulty: Moderate

Step1

Start Access 2007 and open a database that already has a form defined. Select the form for which you wish to create a combo box and click on Design View.

Step2

Select the "Design" and look in the Controls group to ensure that the "Use Control Wizards" icon has been selected. Select it if it is not already active.

Step3

Click on the "Combo Box" tool. Notice how the mouse cursor changes to a crosshair and combo box icon, which shows you are ready to insert a combo box. Position the crosshairs on the form where you wish to place the combo box and click. This will start the Combo Box Wizard.

Step4

Choose between displaying a list from a data source and manually entering a list of fixed values. Follow the prompts related to the appearance of the values. Now, you will need to decide between a bound control, which is associated with a data source, and an unbound control where the value must be retained for later use.

Step5

Enter the label for the control on the next screen of the Combo Box Wizard and click the "Finish" button to complete the wizard.