requery tabs subform data if other tabs subform changes

C

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
 
T

Tom Wickerath

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
 
Top