Tab Subforms

  • Thread starter Thread starter Ron
  • Start date Start date
R

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
 
Try the "gotfocus" event for the subform on each tab. Most of the other
events are useless.
 
Ron said:
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?
Click to expand...


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.
 
Back
Top