Tab Subforms

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
 
J

JimS

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

Marshall Barton

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?


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top