How to Create a Drop-Down List in Access 2007

Written by leigh thompson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a Drop-Down List in Access 2007
(Creatas/Creatas/Getty Images)

Microsoft Access utilises forms to enter information into the underlying table. A drop-down list is a control used in an Access form. These combo boxes feature a down arrow that when clicked displays a list of selections that you can choose from. Once you select the information, it is stored in the field associated with this control. Combo boxes are helpful to guarantee accuracy and uniformity of the information in your table.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open your Access database. Click the "Create" option on the top bar. Choose the "Form" button located in the "Forms" group. Right-click a form and choose "Design View" to change an existing form.

  2. 2

    Click the "Combo Box Control" from the "Controls" group.

  3. 3

    Click a blank place on the form and drag a box to create the control. Choose a method of filling the control.

  1. 1

    Choose the radio button next to the option to use values from an existing table or query. Choose the table or query from the list. Click the "Next" button.

  2. 2

    Add the fields to your lookup query. Click the ">" button to add fields to your combo box. Click the "Next" button.

  3. 3

    Add sorting levels to put your data in alphabetical or numerical order. Click the "Next" button. Adjust the width of your lookup columns. Click the "Next" button.

  4. 4

    Choose the option to store the value for later use. Click the "Next" button. Enter a name for the label. Click the "Finish" button.

  1. 1

    Choose the radio button next to the option to manually enter data. Click the "Next" button.

  2. 2

    Choose the number of columns you want to add to your combo box. Type your lookup box information into the columns. Click the "Next" button.

  3. 3

    Choose the option to store the value for later use. Click the "Next" button. Enter a name for the label. Click the "Finish" button.

  1. 1

    Click the control. Press the "Property Sheet" button on the "Design" ribbon. Click the "Data" tab. Enter a control source. Click the drop-down box next to control source and choose the field you want to store the information in.

  2. 2

    Click the "View" button on the top menu. Choose "Form View" from the list of options. Click the drop-down box to test that it works correctly.

  3. 3

    Click the "Microsoft Office" button. Choose the option to "Save" the form. Name your form. Click the "OK" button.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.