Form Tab order while entering data

[Bec_FS]

I have come across a problem in my forms which is a little annoying. I have
a form several fields and subforms on it. I have set the tab order in design
mode and everything tabs through correctly except for in some situations.
One time some of the fields had no data, so I skipped those fields by using
my mouse and then clicking back up to the first record and then starting a
new record. Well when I starting entering data again using the tab/enter
key, the form takes you to where you left off on the last record. What I
would like the form to do is start back up at the first record and tab
through as I have specified in the tab order.
My question is...Is there a way to refresh when you start a new record so
that it does not start back where you left off in the previous record?
Thanks for any help

 

[Linq Adams via AccessMonster.com]

Normal behavior for Access is that the control with focus on RecordA retains
focus when you move to RecordB. To have focus always go to the first control
in your tab order

Private Sub Form_Current()
Me.FirstTextBox.SetFocus
End Sub

To only have this behavior when you go to a new record:

Private Sub Form_Current()
If Me.NewRecord Then
Me.FirstTextBox.SetFocus
End If
End Sub