Linking Combo Boxes (1 Viewer)

A

AccessChallenge

Guest
I have been working on this for about an hour and half and need someone's help. I have two combo boxes that should be linked. I am working for a educational body and need to link a combo box containing the district names to a combo box listing the schools located in the chosen district. Here are the tables that I have made:

District
DistrictID (PKey)
District_Name


Schools
SchoolID (PKey)
DistrictID (Foreign Key to District Table)
School_Name

The two combo boxes are called cboDistrict and cboSchool respectively.


Any Help would be appreciated. Thanks.

AccessChallenged
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 08:35
Joined
Aug 30, 2003
Messages
36,118
Search here on "cascading" combo boxes, which is the common term for that, and you should find numerous examples.
 

Users who are viewing this thread

Top Bottom