Tab Subforms

[Ron]

Hi,
I have a form that uses tab control to switch between multiple subforms.
Each subform references a different table as a recordsource. I have no
trouble using refresh/requery on combo boxes to reflect additions performed
in one subform and another.
I can't get this technique to work when a value is edited in one subform and
displayed in another. I've tried refresh and requery on the affected subform
to no avail. What event is given control when switching from one tab to
another?
Thanks

 

[JimS]

Try the "gotfocus" event for the subform on each tab. Most of the other
events are useless.

 

[Marshall Barton]

I have a form that uses tab control to switch between multiple subforms.
Each subform references a different table as a recordsource. I have no
trouble using refresh/requery on combo boxes to reflect additions performed
in one subform and another.
I can't get this technique to work when a value is edited in one subform and
displayed in another. I've tried refresh and requery on the affected subform
to no avail. What event is given control when switching from one tab to
another?

The tab control's Change event fires whenever a tab is
selected. You can determine which tab by using the tab
control's Value property.