Access Combo box Populate With Table Values

Jul 10, 2015 by azurous in Access

In this article I will explain how you can populate a combo box with values from an Access table.

Consider the following table:

The table name is:

“Students”

The table has 5 fields:

“ID”
“First Name”
“Last Name”
“Phone Number”
“Email”

Consider the combo box below. Assume we want to fill it with data from a field from the table:

–

Contents

Step 1:

Open the form in design view, and select the combo box by either clicking on it or selecting it from the the drop down list on the property window:

–

Step 2:

Change the Row Source Type to Table/Query:

–

Step 3:

In the Row Source property click on the 3 dot button:

The query builder will open. Here you can define a query. The result of this query will populate the combo box. After defining the query click on the close button and save:

–

Example 1:

Lets say we want to fill the combo box with the first name of the students. After following the 3 steps above, in the query builder create a query that will return the first names of the students from the “Student” table. After creating the Query click on the Close button and save upon closing:

SQL Statement:

SELECT Students.[First Name] FROM Students;

Result:

–

Example 2:

In this example we want the combo box to display the first names of all the students whose ID is between 3100 and 3105:

Query Criterion:

[Students].[id]<3105 And [Students].[ID]>3100

SQL Statement:

SELECT Students.[Last Name] FROM Students WHERE (([Students].[id]<3105 And [Students].[ID]>3100));

Result:

You can download the sample file used in this article from the link below:

Populate Combo Box.Zip