Cascading dropdown boxes using Access 2016

[Jimbo13]

Please bear with me, I have a problem that entails dependent dropdown boxes. I will try to explain it clearly.
OK, I have the first combo box set to provide a list of manufacturers and that works just fine. Once I select a manufacturer combobox, then I want it to dictate one of 8 choices for the rowsource of the next combobox.
I have looked through many of the solutions for this and none seem to work. Could it be that Access 2016 works differently than previous versions? I have been :banghead: trying a variety of solutions and none seem to work. I am sure I have erred somewhere but I do not know where.
Please help

 

[pbaldy]

Generally speaking, 2016 should work the same as previous versions. What exactly did you try, and what exactly isn't working?

 

[Jimbo13]

PBaldy,
I have looked though your threads as well as many others here and they haven't helped me. Maybe this will be more descriptive;
I have a Table that we will call Manufacturer then depending on the selection that will dictate one of 8 other tables that should populate the next combo box. I have tried using the After_Update of combox 1 (which works just fine) tried VBA code with CASE statements and SWITCH statements with no luck, also nested IIF's but no go. So I am at a loss.................

 

[Jimbo13]

PBaldy - here is a zipped version of what I have so far - maybe that will help.

 

[Jimbo13]

pbaldy, also thanks for your help and the form in question would be frmRoofInfo that is misbehaving

 

[pbaldy]

The bound column of the manufacture combo is the ID, not the name, so you have to test for that.

 

[Jimbo13]

Paul,
Thanks I will give that a try and let you know, all else look kosher? Any other advice would be gladly appreciated.

Jim

 

[Jimbo13]

Paul,

Thank you soooooooooooooooo much, I knew it was a mistake in my logic somewhere - now I can muddle with the rest. Udaman

 

[pbaldy]

Happy to help! I would likely not have tables for each manufacturer, I'd have a single table with an extra field for manufacturer.