A combo box control is what combines features of a text box and a list box. A combo box is used when one wants to have the option of either typing in a value or selecting a value from a predefined list.
How to Create a List box or Combo box using the Wizard in Access.
Create a list box or a combo box by using a wizard
- Right-click the form in the Navigation Pane, and then click Design View.
NOTE – This procedure assumes that the form is bound to a table or query. Some of the steps will not apply if the form is unbound. To determine if the form is bound to a table or query, press F4 to display the property sheet. On the Data tab of the property sheet, the Record Source property box displays the table or query that the form is bound to.
- On the Design tab, in the Controls group, ensure that Use Control Wizards is selected.
- Click either the List Box tool or the Combo Box
- On the form, click where you want to place the list box or combo box.
- Depending on your choice, the List Box Wizard or the Combo Box Wizard starts.
- When the wizard asks how you want to get the values for the control, do one of the following:
- If you want to display the current data from a record source, click I want the list box/combo box to look up the values in a table or query.
- If you want to display a fixed list of values that will seldom change, click I will type in the values that I want.
- If you want the control to perform a find operation, rather than serve as a data entry tool, click Find a record on my form based on the value I selected in my list box/combo box. This creates an unbound control with an embedded macro that performs a find operation based on the value the user enters.
- Follow the instructions for specifying how the values will appear.
- If you chose one of the first two options on the first page of the wizard, the wizard asks what you want Access to do when you select a value. Do one of the following:
- To create an unbound control, click Remember the value for later use. This means that Access will hold the selected value until the user changes it or closes the form, but it will not write the value to a table.
- To create a bound control, click Store that value in this field, and then select the field you want to bind the control to.
- Click Next and type a label for the control. This label will be displayed next to the control.
- Click Finish.