filtering subform based on other subform

[potts]

I have a form with two subforms. The second subform is really a subform of the first subform - confused?

Ok. MainForm has many records in SubForm1. SubForm2 has many records in SubForm2. I know I can have two levels of sub forms in a main form. However, the problem with this is that I want the information in SubForm1 to be displayed as continuous forms and you can only use single forms if you have a subform embedded. Therefore, linked forms would seem to be the solution. I would simply leave it like this (SubForm1 embedded in MainForm, SubForm2 linked to Subform1) except that I want to keep all the information grouped together with minimal controls linking them. So... I was wondering if it is posible to filter the values in Subform2 based on the current record in Subform1 when they are both embedded as 1st level subforms in MainForm.

I know there is nothing like making life difficult for yourself, but any help would be great all the same. Thanks.

 

[llkhoutx]

Set the Master & Child Link properties of the subform2. Requery the subform2 on the AfterUpdate event of the Master Link (in subform1).