Hi Dan,
I'm fairly new at this, so please don't hold me to this, but I think you are having the same problem I was having the other day.
If you are using multiple combo boxes in one form (and it definitely sounds like you are) you probably want to cascade them.
Although I can't exactly...