Dependent Combo Box/ List Box Example

The Access form dependent combo is one of the first techniques a new programmer must master.  Hopefully the downloadable example will save you a lot of time figuring out your first dependent dropdown list code.

This example demonstrates the Tables, Queries and form programming to setup a combo box dropdown list dependent on the values in another combo box.

In this demo we have a list of Student Advisors and a list of Students.  When you select an advisor the dependent combo box (students) is limited to those students who have been assigned the selected advisor.

Here is a snapshot of the code contained in the database:

Main combo after update event:

Private Sub Advisor_Combo_AfterUpdate()
Me.Student_Combo.Requery
End Sub

Record source for the dependent combo:

SELECT M_Students.Student FROM M_Students WHERE (((M_Students.Advisor_ID)=[Forms]![F_Combo]![Advisor_Combo]));

Download our Access Dependent Combo Box programming example.