what you want it is typically referred to as a cascading combo box, but I like your description better as nothing cascades from one to the other, like a waterfall does. I thought about mounting a campaign to change the Access world but couldn't raise the funding
There must be a million pages out there on how to do it. Here's one http://www.fmsinc.com/microsoftacces...cascading.html
No code needed.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.