View Full Version : subforms and tab controls


JJ
04-07-2000, 01:12 PM
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 http://www.access-programmers.co.uk/ubb/smile.gif Thanks.

Travis
04-07-2000, 09:54 PM
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
04-09-2000, 01:32 PM
Would I accomplish this through a applyfilter macro? Something like:

Subform!ClientID = Sub-subform!ClientID