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:
Other People Are Reading
Open your Microsoft Access database. Right-click your form and choose "Design View."
Right-click the combo box and select "Properties" from the list.
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.
Click "File" and "Save." Close the form.
Format Combo Box
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."
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.
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:]
Click "Run" on the top ribbon. Save the query when prompted.
Enter a search keyword into the prompt. The query will pull all matching information from your combo box field.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for