requery tabs subform data if other tabs subform changes

[Chris]

I have a tab control where two of the tabs have subforms. If the user
changes info on one of the subforms it should show up on the other tabs
subform. I assume I need to requery the data for the other subform and
initiating this when they click on the tab page for the other subform

I have the following on the click event of the tab control but it doesn't
seem to run

Private Sub Dispatch_Click()

'refresh form with any changes from request tab subform
Me.DispatchSubform.Form.Requery

End Sub

Dispatch is the name of the tab control page

Can't see why this is not working
Thanks
Chris

 

[Guest]

Hi Chris,

Try this example:
Tip #10: Late Bind Subforms on Tab Controls
http://www.fmsinc.com/free/tips.html#accesslatebind


Tom
________________________________________

:

I have a tab control where two of the tabs have subforms. If the user
changes info on one of the subforms it should show up on the other tabs
subform. I assume I need to requery the data for the other subform and
initiating this when they click on the tab page for the other subform

I have the following on the click event of the tab control but it doesn't
seem to run

Private Sub Dispatch_Click()

'refresh form with any changes from request tab subform
Me.DispatchSubform.Form.Requery

End Sub

Dispatch is the name of the tab control page

Can't see why this is not working
Thanks
Chris