subforms and tab controls

[JJ]

This is kinda confusing, so forgive me. I've got a form (1st level) with a subform (2nd level) with a combo box. The combo box determines which record appears in the subform (2nd level). This subform (2nd level) also has a subform (3rd level), which shows the sub-subform (3rd level) records for the value selected in the combo box in the subform (2nd level). Within the subform (2nd level) this works fine. When I change the combo box value, the sub-subform (3rd level) changes as well. However, I would like to place the sub-subform (3rd level) on a separate tab page within the original form (1st level) rather than leave it within the subform (2nd level). When I drag the sub-subform (3rd level) into the tab page, the sub-subform (3rd level) no longer changes when the combo box value of the subform (2nd level) changes. How can set the sub-subform to follow my combo box value? If you can even understand this question, I'll be amazed

Thanks.

 

[Travis]

Since the Sub-SubForm is now no longer linked Child/Parent with the Sub Form you will need to use the AfterUpdate of the Sub Forms Combo Box to refilter the Sub-SubForm on the Tab area.

Hope this untangles your thought

 

[JJ]

Would I accomplish this through a applyfilter macro? Something like:

Subform!ClientID = Sub-subform!ClientID