How to Use an Access Form Combo Box Column as the Filter for a Query

Written by leigh thompson
  • Share
  • Tweet
  • Share
  • Email

Combo boxes are also referred to as drop-down boxes and store information in an underlying table. In order to filter by combo box, you must designate a control source. This control source is the table field where your information is saved. Once this is done, a parameter query can filter that information. Parameter queries generate prompts when a query is run and a box appears with instructions. The user types in a search phrase and the query pulls any information that matches your search.

Skill level:
Moderate

Other People Are Reading

Instructions

    Format Combo Box

  1. 1

    Open your Microsoft Access database. Right-click your form and choose "Design View."

  2. 2

    Right-click the combo box and select "Properties" from the list.

  3. 3

    Click the "Data" tab. Click the drop-down box next to "Control Source." Choose the field in which you want to store the combo box data.

  4. 4

    Click "File" and "Save." Close the form.

    Create Query

  1. 1

    Click "Create" on the top ribbon. Click the button for "Query Design" and choose the table that contains your combo box field. Click "Add" and then "Close."

  2. 2

    Click the first column "Field" box and choose the combo box field. Repeat this step in the subsequent columns with all other table fields you want to show in your query.

  3. 3

    Set parameters for your combo box field. Type a statement into the criteria row that instructs the user what information to enter. For example:

    [Find Last Name:]

  4. 4

    Click "Run" on the top ribbon. Save the query when prompted.

  5. 5

    Enter a search keyword into the prompt. The query will pull all matching information from your combo box field.

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.