How can I filter one Microsoft Access combobox based on another combobox selection?
The following article describes how to synchronize two Microsoft Access combo boxes so that when you select an item in the first combo box, the selection limits the choices in the second combo box.