Question on entering data using a form

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
 
A

Al Campagna

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."
 
M

Mike Slater

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...
 
Top