Hi all,
I want to be able to limit a combobox to a list which is depended on the first 2 comboboxes.
I have a Master Catgegory, when selected you move onto the 2nd combo the 2nd combo is depedant on what is selected in the Master Catergory combo. The 3rd combo is dependant on the 2nd combo, the problem I have at the moment is that each combo behaves indepdantly hence my lists are too long, i need to limit them. I am not sure what should be entered as the ROWSOURCE for these combo's
e.g I have the third combo as :
ROWSOURCE:
SELECT DISTINCTROW Products.ProductID, Products.ProductDescription, Products.Weightlb, Products.Weightkg
FROM Products;
This just displays all the products, i need it depandant on the first and second as described above.
Any ideas ?
many thanks
I want to be able to limit a combobox to a list which is depended on the first 2 comboboxes.
I have a Master Catgegory, when selected you move onto the 2nd combo the 2nd combo is depedant on what is selected in the Master Catergory combo. The 3rd combo is dependant on the 2nd combo, the problem I have at the moment is that each combo behaves indepdantly hence my lists are too long, i need to limit them. I am not sure what should be entered as the ROWSOURCE for these combo's
e.g I have the third combo as :
ROWSOURCE:
SELECT DISTINCTROW Products.ProductID, Products.ProductDescription, Products.Weightlb, Products.Weightkg
FROM Products;
This just displays all the products, i need it depandant on the first and second as described above.
Any ideas ?
many thanks