ms access form tab control events
Private Sub YourTabbedControl_Change() If Me.YourTabbedControl.Value = 0 Then 'First Page 'Do code for Page 1 ElseIf Me.YourTabbedControl.Value = 1 Then 'Second page 'Do code for Page 2 ElseIf Me.YourTabbedControl.Value = 2 Then 'Third page 'Do code for Page 3 End If End Sub
Source: www.access-programmers.co.uk