Subform in Tab Control Won't Update

[Guest]

i have a form that has a subform in the Detail Section and in the Footer a
Tab Control containing subforms related to the Detail Section's subform. When
I add or delete a line of data in the Details section subform, I want the
subform in the tab control (in the footer section) to update and display the
new line/deleted line. Both these forms are display data from the same table
just different fields.

How do I get the subform in my tab control to update properly and show the
added/deleted lines?

Pamela

 

[Pavel Romashkin]

i have a form that has a subform in the Detail Section and in the Footer a
Tab Control containing subforms related to the Detail Section's subform. When
I add or delete a line of data in the Details section subform, I want the
subform in the tab control (in the footer section) to update and display the
new line/deleted line. Both these forms are display data from the same table
just different fields.

How do I get the subform in my tab control to update properly and show the
added/deleted lines?

Pamela

If your footer subforms are supposed to link to a field in the detail
section sf and not to a field in the parent form, you need to manage the
link yourself, which can be done by using a hidden text box on the main
form.

If the data in subforms is actually the same, it might be sufficeint to
simply requery the subforms in the footer. You should do that in the
Current event of the subform in the Detail section. You can easily see
if this will help if, after deleting/sdding records in the detail
section sf, you press F9 and the footer subforms update.

Good luck,
Pavel