I've posted this a few times without any luck, hoping for some fresh
ideas on this. I'm pretty certain this can be done.
I've been using a micrsoft template to create a supplier database
called the Inventory management database, I have changed this so that
there is a link in the relationships with the suppliers so that every
product entered has a specific supplier related, thats fine the main
problem I've encountered is setting up the combo boxes.
When the SupplierID is selected in the main form I want the productID
inside the subform to limit its list from everyone to just that
supplier.
I have looked on this site:
http://www.techonthenet.com/access/c...ked_combos.php
involving Populating one combo box based on the selection of another
combo box
It works great on one form only can it work with a subform set up like
the one I have?