That's quite a standard thing to do in MS Access:
Dropdownbox 1 is your main criterion. The contents of dropdownbox 2 are dependent on what you choose in dropdownbox 1. The contents of dropdownbox 3 are dependent on the the contents of dropbox 3.

Kees