Creating a driving relationship on a form

[ld8732]

I have created an access database for tracking support tickets for multiple school districts. Each school district has multiple schools. I want to be able to choose the district on the form and have the drop down list for the schools be only those schools that are in that district. I cannot figure out how to do that. Anybody have any ideas. I am very new to access form design. Thanks in advance.

[RuralGuy]

That is called Cascading Lists: http://www.fontstuff.com/access/acctut10.htm