I have a parent-sub form (not linked). The five subs are in a tab control with five tabs (one sub per tab). I would like the after update of the combo box on the parent to go to tab 1 of the tab control. This is my code.



Private Sub cmbState_AfterUpdate()
DoCmd.GoToControl "TabCtlCommodities"
DoCmd.RunMacro "macProcessingMessageOpen", 1
Me.frmsubZipToolBatteries.Form.RecordSource = "qryZipToolTabControlBatteryNew"
DoCmd.RunMacro "macProcessingMessageClose", 1
End Sub

Any thoughts on how I can do this? The current problem is that I could be on tab 3 and change the combo box and it does not change the focus back to tab 1.