Look Up

[John]

I have created a list of products from suppliers. I have also created a
subform where the user can select the products they want. The main
problem is this list in the subform (combo box) has every product from
every supplier. I want the list to be unique to the supplier, so only
the products in the drop down are from that supplier. The supplier is
selected form the main form first and then in the subform the user
selects the prodct.

[Phil Stanton]

Assumund the product table is something like
ProductID Autonumber
ProductDescription Text
SupplierID Numner (Long Integer)

All you need to do is ensure that the LinkMasterFields and LinkChildFields
in the subform both say SupplierID

Phil
"John" <da********@hotmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...

>I have created a list of products from suppliers. I have also created a
subform where the user can select the products they want. The main
problem is this list in the subform (combo box) has every product from
every supplier. I want the list to be unique to the supplier, so only
the products in the drop down are from that supplier. The supplier is
selected form the main form first and then in the subform the user
selects the prodct.