Requery Subform on a Tab Control

[Jen]

Hello -
I have frm_main that contains a tab control with 2 tabs.
On each tab, there is a subform
Tab 1 - Over Under = frm_OverUnder_sub
Tab 2 - Usage = frm_CompareSub
I want the frm_comparesub to update on click since it
summarizes data that is entered on frm_overUnder_sub.
In the on click event of the "Usage" tab I have
Me![frm_compareSub].[Form].Requery

This must be wrong since it is not updating.
Any suggestions?
Thanks,
Jenni

 

[Rick Brandt]

Hello -
I have frm_main that contains a tab control with 2 tabs.
On each tab, there is a subform
Tab 1 - Over Under = frm_OverUnder_sub
Tab 2 - Usage = frm_CompareSub
I want the frm_comparesub to update on click since it
summarizes data that is entered on frm_overUnder_sub.
In the on click event of the "Usage" tab I have
Me![frm_compareSub].[Form].Requery

This must be wrong since it is not updating.

The Click event of a TabPage is not what you think it is. That fires when
you click on the background of the TabPage already "in front". The event
that fires when you change TabPages is the Change event of the TabControl
itself.

 

[Jen]

THANK YOU!
It was driving me crazy since I was pretty sure my code
was correct.
Cheers, Jenni.

-----Original Message-----

Hello -
I have frm_main that contains a tab control with 2 tabs.
On each tab, there is a subform
Tab 1 - Over Under = frm_OverUnder_sub
Tab 2 - Usage = frm_CompareSub
I want the frm_comparesub to update on click since it
summarizes data that is entered on frm_overUnder_sub.
In the on click event of the "Usage" tab I have
Me![frm_compareSub].[Form].Requery

This must be wrong since it is not updating.

The Click event of a TabPage is not what you think it is. That fires when
you click on the background of the TabPage already "in front". The event
that fires when you change TabPages is the Change event of the TabControl
itself.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.