Filtering table based on combo box selections

[frispee]

Hi,

I have a form with two combo boxes (Supplier and Plant). In the same form I have a table in datasheet view as a sub-form which shows all suppliers and all plants. I want to be able to select a supplier and a plant and I want the table to show only the entries matching that criteria. Any suggestions?

Thank you in advance

 

[jdraw]

What you are asking about is known as Cascading Combo boxes.
There are free video tutorials at
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

There is info here also
http://www.baldyweb.com/CascadingCombo.htm