Microsoft Office Access 2010: Example of a Form with a Combo Box Control

Purpose of This Programming

Forms and Form Controls are User-friendly tools to add, move or modify data from one Table to another. The Combo Box can use a Table or Query to look up, filter or select the data.

 

The next three lessons will program several Combo Box Controls to do the following:

 

Use a Table to Add Data to Another Table

This lesson will create a Combo Box to the Movie Form. The Combo Box will be used to add data from the Rating Table to the Movie Table.

 

Use a Table to Filter Data in Another Table

The next lesson will create a movie search form. This form will use a Combo Box to filter the data in the Movie Table.

 

Use a Query to Select Specific Data

A Query can be a Record Source for a Form as well. The following lesson modifies the movie search form with synchronized Combo Boxes.