Return to New Record

[JJT]

Is there a way for me to customize my form so that when I press the "Enter" key, I move
to a new record ?

Thanks.

 

[jwindon]

Create a command button that moves to a new record. On the OnCurrent event of your form, set the focus to the command button. Then when you hit ENTER it will actually "Click" the command button.

The code for the OnCurrent to put in between the Private Sub ??????_Click()

is

Me.CommandButtonNameGoesHere.SetFocus

Hope that helps you out.