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? I have just started out using VBA and would greatly appreciate any help.

Thank you in advance

[rivereridanus]

You can actually do this outside of vba if you want. Here's how:
Once you have your combo boxes set up and the table in the form, select the table subform and go in the properties window under the Data tab. Source Object shoule be the name of your table. Link Master Fields indicates the combo boxes, and Link Child Fields indicates the subform. So it sounds like yours should be like this:
Source Object: [name of table]
Link Master Fields: Supplier;Plant
Link Child Fields: Supplier;Plant
Filter On Empty Master: Yes

[frispee]

@riveridanus: Thanks a lot! it works