ComboBox criteria

[Guest]

, Hi all community,,

I have form with two combobox, but I want this,,

One is: SupplierID Second is: ProductsID

but I want to add a criteria that is I selected "Mark Products company" in
first ComboBox, the second combobox only show products from "Mark Products
company" and so successively...

I already have a relationship between SupplierID and ProductsID

can anyonw help me please..

Thanks ..

ldiaz


ldiaz

 

[Rick B]

This is asked and answered almost every day. Did you try searching the
newsgroup first?

Look for "cascading combo box"

 

[Guest]

Hi Rick,,,I found information, but this can be applied also in subform. and
also in three combobox???

 

[Rick B]

You can do it in three. Is is a bit more complicated though. I don't think
that being in a subform will matter.

I have seen a few posts lately that talked about how to do this using three
boxes. The theory is still the same. Take a look at them and if they are
too specific, et us know your structure and perhaps we can give you more
detailed instructions.

Personally, I have not built this type of relationship in a while and I
always have to look back at a previous form wher I have it working in order
to build it. That being said, I may not be able to post back detailed
instructions for your exact situation.

 

[Guest]

Thank you..I appreciate your help ,,

Best Regards from Tijuana Mx.