Filtering subform data from the main form

[jevans]

Hello, How can I filter the data in a subform with a combo box from the main form.

Alittle info.

I have a combo box which has three options OPEN,WON,LOST. When I click to OPEN I would like the subform to display only "OPEN" data.
There is a field in the subform named Status with either OPEN,WON,LOST entered into it.

 

[yeatmanj]

It's in how you lay out the forms. First you have to have the field with the options in both the main form and the sub form. Second the Sub form has to be layed out in such a way that it can display all the "Open" records at one time. You set the Parent and Child Fields Property of the SubForm box that shows in design view on teh main form to be the name of the field you are using to select from. I think that's it.