What Does Microsoft Access List or Combo Box Mean

A combo box control combines features of a text box and a list box. A combo box allows users to either type in a value or select 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 combo box using a wizard by following these steps:

  1. Right-click the form in the Navigation Pane, and then click Design View.
  2. NOTE: This procedure assumes that the form is bound to a table or query. To check if the form is bound, press F4 to display the property sheet. On the Data tab, the Record Source property box shows the table or query the form is bound to.
  3. On the Design tab, in the Controls group, ensure that 'Use Control Wizards' is selected.
  4. Click either the List Box tool or the Combo Box tool.
  5. On the form, click where you want to place the list box or combo box.
  6. Depending on your choice, the List Box Wizard or Combo Box Wizard starts.
  7. When the wizard asks how you want to get the values for the control, choose one of the following: - To display current data from a record source, select 'I want the list box/combo box to look up the values in a table or query.' - To display a fixed list of values, select 'I will type in the values that I want.' - To perform a find operation instead of data entry, select '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.
  8. Follow the instructions for specifying how the values will appear.
  9. If you chose one of the first two options, the wizard asks what Access should do when a value is selected: - For an unbound control, click 'Remember the value for later use.' - For a bound control, click 'Store that value in this field' and select the field to bind the control to.
  10. Click Next and type a label for the control. This label appears next to the control.
  11. Click Finish.

Have a question? Ask us!