Filter form records using subform

[nnaacc]

I've got a form of firms, with two subforms - contacts (one to many relationship) and mailing lists (one to one relationship).<br>
<br>
I can filter records on the form, and the subform records are filtered.<br>
<br>
When I filter using a field in one of the subforms, that subform is filtered, but all of the records in firms are still available.<br>
So if I filter for a contact Smith, the result is I can flip through all the firms, each with the contacts subform blank except if the firm has a Smith.<br>
<br>
How can I filter the records of the &quot;master&quot; form from a subform?<br>
<br>
Thanks in advance for your help.<br>

 

[DougP]

You're Link is from Master form to the subform in both cases<br>
So the subforms only look to the master for information<br>
If you want on esub to look at something differnt.<br>
Add a second &quot;In-Visible&quot; Text box on your main form.<br>
make it's control source look at the a field on the first subform.<br>
Make the Master/Child Link on the second subform look at the in-visible text box<br>
<br>
So when you change the information on the first sub form the second will follow suit.<br>
<br>
OK<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>