Difficulties with Syncronizing 3 Combo Boxes

[ToddNYC]

I have been trying for several days to get these 3 combo boxes to synchronize but haven't been able to figure it out yet. There are many posts on the topic, but I think I'm making it worse by combining the ideas from various posts all together! I was able to get the first two boxes to work, but yesterday I revised the order of the table data based on an article I read and now I can't even get any to work.

Any advice/suggestions would be appreciated!

I've attached a shortened version of the Access file.

Thanks, Todd

 

[MarkK]

See if that makes sense to you...

 

[ToddNYC]

Thank you so much for the quick reply! It does work perfectly in this example, I am still trying to integrate it into my larger database and write to the tables etc.. I'll keep banging away at it and I appreciate your help and time.

Todd