show combo box records based on another combobox

[tweety]

Hi


I have a form (supplier) with a subform (purchase ID and date) and another subform (this list the order details)

the form is used to record supplier orders, i have 3 suppliers and 10 products.

http://datapigtechnologies.com/flash...combobox2.html i tried the link above so the after i select the supplier name from the combo box, the product combo box only shows 3 products and not all 10.

both combo boxes get their data (values) from a table

thanks in advance

[alansidman]

Look at this link on cascading combo boxes.

http://www.fontstuff.com/access/acctut10.htm