Hello all,
I'm in the process of creating an inventory database and have encountered a significant road block.
I have a form/subform problem where I have a combo box called "Supplier" on the main form, and I have products (another combobox) in the subform.
I'm trying to get ONLY the products of the selected supplier (in the main form) to show in the combobox of products in the subform.
I was able to accomplish this (update products based on supplier), within the same form, but cannot accomplish this when dealing with a form/subform.
I'm not too familiar with VB or SQL code, so please help solve my problem step by step !!!
Thanks so much.