Question on entering data using a form

  • Thread starter Thread starter Mike Slater
  • Start date Start date
M

Mike Slater

First, I am a new to creating databases and Access. I have some basic forms
that I use to enter data into tables. The problem I am having is that when I
complete a form and press 'Enter' to bring up a new blank form, the cursor
stays in the last box on the form. I would like the cursor to return to the
first box on the form. Any help is appreciated. Thanks.

Mike
 
Mike,
Normally, Access stays on the same field as you browse form one record
to another.
Use the form's OnCurrent event to...
DoCmd.GoToControl "YourFirstControlName"
or
FirstControlName.SetFocus
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thanks Al. Much appreciated.

Mike


Al Campagna said:
Mike,
Normally, Access stays on the same field as you browse form one record
to another.
Use the form's OnCurrent event to...
DoCmd.GoToControl "YourFirstControlName"
or
FirstControlName.SetFocus
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
Click to expand...
 
Back
Top