Sub Form controled by Combo Boxes in Main Form

[TreeHugger4]

I don't have a lot of experience using Access and could really use some help on this!

I have a Form "Main" and a SubForm "MainSub". In the Main Form there are 4 combo boxes (State, Customer, Product, Category). When the four boxes are filled, I would like the data to be displayed in the Sub form. The Sub form's Record Source is the MasterTable. I have all Data the in a Table "MasterTable". Let me know if you need more info about the set up or what I am trying to do. Thanks so much!!!!

 

[Uncle Gizmo]

Do you mean you want the results in the sub form to be filtered by the selections in the 4 combo boxes (State, Customer, Product, Category).

 

[TreeHugger4]

Yes. But I don't know how to link the form and sub form... Or maybe the combo box selections to the results in the sub form.

 

[Uncle Gizmo]

You may find this link useful

http://msaccesshintsandtips.ning.com/profiles/blogs/allow-a-combo-box-to-return

 

[TreeHugger4]

I will check it out. Thanks!