Here is a great tip and example from the MS Access team on how to create dropdown boxes that drive what a user can select from additional drop downs. It is also sometimes referred to as cascading combo-boxes (since the first choice 'cascades' to the next list of things a user can choose).
Get the template here
