You are looking to use what are called "cascading combo boxes" in Access forms. The basic concept is that you update the rowsource for the School combo box whenever the District combo box updated. To do that you need a small VBA procedure on the AfterUpdate event of the District combo box that changes the rowsource of the School combo box to match the district that has been chosen. (I assume that you are linking to the SQL Server tables, and are not using the .ADP approach.) If you need more detailed instructions on how to do that, post back, but if you search for the term "cascading combo boxes" you will find a number of examples.