need to link _vendor_ combo box 1 to _ product description_ field in combo box 2.

[Dkriezel]

I'm working on a purchase order form database.
The vendor combo box 1 is populated from a Vendor Table with name and vendor ID number.
Once you pick a specific vendor i want the combobox 2 for product description to only show product approved from that vendor.

I have populated a second table called Product Master Table and have added a vendor id field to this table.


need code for this.

[June7]

This is dependent (cascading) combobox. Review http://datapigtechnologies.com/flash...combobox2.html