Access Combo box Populate With Table Values
In this article I will explain how you can populate a combo box with values from an Access 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;
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));
You can download the sample file used in this article from the link below:
See also:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com