The way I got it to work is to use:
Private Sub TabCtl0_Change()
Select Case Me.TabCt10
Case 0
Me.YourFormNameHere.Setfocus
DoCmd.RunCommand accmdRecordsGoToLast
Case 1
Me.YourFormNameHere.Setfocus
DoCmd.RunCommand accmdRecordsGoToLast
Case 2
Me.YourFormNameHere.Setfocus
DoCmd.RunCommand...
Re: still having issues with this
I have a similar problem to Piet. I tried UncleJoe's code, but the code only works when you click on a different tab. Otherwise the focus is on the first record. Anybody have any tips?