Creating a filter with combo boxes

[Poss]

Hi All,

I have an Access table that contains a list of schools. The first column contains the school names and the second column contains the regions they belong to. There are 1597 schools and 9 regions.

I have 2 combo boxes on a form. The first one is populated with all 9 regions and the second one is populated with all 1597 schools.

I want to be able to select a particular region in the first combo box and see all the schools belonging to that region in the second combo box. How do i go about doing this?

Thanks in advance

 

[jmcilhinney]

Can I assume that you have a table that contains the Region records and each School record contains a foreign key value from that table?