Question on new entry

[Ed Jr.]

I have a form that everytime I hit the Next Record button, it goes to the
next entry but the active command stays on the Next Record button. So
meaning, if I was to hit enter again, it would just keep going to the next
record and the record after that and so on. I would like to make it so when
I tab through or enter info and I get to the next record button and I hit
enter, it would goto the next record but the active box would be the first
text box on the form insead of the next record button. How do I do that?
Thanks for your help!

Ed

 

[fredg]

I have a form that everytime I hit the Next Record button, it goes to the
next entry but the active command stays on the Next Record button. So
meaning, if I was to hit enter again, it would just keep going to the next
record and the record after that and so on. I would like to make it so when
I tab through or enter info and I get to the next record button and I hit
enter, it would goto the next record but the active box would be the first
text box on the form insead of the next record button. How do I do that?
Thanks for your help!

Ed

In the form's Current event:
[FirstControlName].SetFocus

 

[Ken Snell]

In the form's OnCurrent event, put this code (change name of textbox to real
name):

Private Sub Form_Current()
If Me.NewRecord = True Then Me.NameOfTextBox.SetFocus
End If