Question on new entry

  • Thread starter Thread starter Ed Jr.
  • Start date Start date
E

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
 
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
Click to expand...

In the form's Current event:
[FirstControlName].SetFocus
 
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
 
Back
Top