Tab Control Button to Start a New Record and Return to First Tab

[ProvPC]

I have a form that uses a tab control with three tabs. Thanks to information I've been able to gather from other threads, I've been able to create buttons at the bottom of the first tab to move the second tab, and again to move from the second tab to the third.



What I'd like to be able to do is create a button on the third tab that submits the record (or, I suppose, starts a new record) and shifts the user back to the first tab to begin again.

If it matters at all, this is how I'm advancing the between the tabs (I'll name it correctly when I have it all working):

Private Sub Command73_Click()
Me.ERG_TabCtrl.Value = ERG_TabCtrl.Value + 1
End Sub

[aytee111]

Do the same as what you did for the others - set the value to 0 and start a new record (DoCmd.GoToRecord,,acNewRec).

[Bulzie]

Maybe also set focus to the first field in Tab1 after saving?

Me.yourfield.Setfocus

[ProvPC]

Do the same as what you did for the others - set the value to 0 and start a new record (DoCmd.GoToRecord,,acNewRec).

Thank you - that worked perfectly!

[ProvPC]

Maybe also set focus to the first field in Tab1 after saving?

Me.yourfield.Setfocus

This is a great idea, and something I hadn't even thought about! I tried adding this to the script, but I think I must have done something incorrectly. Here's what I have:

Me.ERG_TabCtrl.Value = ERG_TabCtrl.Value = 0
DoCmd.GoToRecord,,acNewRec
Me.HoHFirstName.Setfocus

HoHFirstName is the name of the first field on the first tab of the form. The error I receive is:

Compile error:
Method or data member not found

As it happens, removing that line from the script altogether submits the record, and moves me to the first tab with the focus on the first field already, so it worked out splendidly. Thanks for your suggestion!

[Bulzie]

Yeah you might have needed to use the full path to reference the field like Forms!frmMain!HoHFirstName.SetFocus but if it works regardless that's even better.