ComboBox criteria

L

ldiaz

, 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
 
R

Rick B

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

Look for "cascading combo box"
 
L

ldiaz

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

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.
 
Top