Using multiple combo boxes to populate a subform

[Butterfly807]

Hello! I've created a form and am having difficulty linking my 2 combo boxes to the subform within the form.

I've been able to figure out how to link the combo boxes to each other so that in the first combo box I can select a category "bag" and then the second combo box provides me with the only 2 options to go with "bag": "sandwich" or "tool".

Once I have selected "Bag" in the first combo box and "tool" in the second combo box, I then want a list of suppliers that sell tool bags to populate into the subform. I have been working for WEEKS to get the subform to populate data rather than remain empty. :banghead:

I would GREATLY appreciate some guidance to get my subform to work.

Thanks!

 

[Shallo9]

Greetings and welcome to AWF. Could you please upload a sample of those three combo boxes along with the tables so one of us can look into it.

As every problem is independent I might be prejudice in providing you with an example.

 

[Shallo9]

Hi,

Please find attached a sample databse ...See if this is something you were looking for...Or atleast the logic