requery of sub forms on tab control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

my forms on tab control are not requerying using the following code on the
change tab event, can some one please help.


Private Sub TabCtl5_Change()
Select Case Me.TabCtl5.Value
Case 0
Me.Check_List.Requery
Case 1
Me.Summary.Requery
Case 2
Me.ETB.Requery
Case 3
Me.ETB_Analysis.Requery
Case 4
Me.Inter_co.Requery
Case 5
Me.PN_GN.Requery
Case 5
Me.Balance_Sheet_and_Income_Statement.Requery
Case 6
Me.Statement_of_Cashflow.Requery

End Select

End Sub
 
Got the problems sorted for others who have the same issue, the following
worked for me - event procedure "On Change" for the tab control

Private Sub TabCtl5_Change()
On Error GoTo Macro2_Err

DoCmd.RunCommand acCmdRefreshPage


Macro2_Exit:
Exit Sub

Macro2_Err:
MsgBox Error$
Resume Macro2_Exit

End Sub
 
Back
Top