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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save data entered into a form 5
OnClick on Combo Box opens a New Form 0
Need Carriage Return after Data Entry 1
Restrict entering Null or Empty in Textbox - Access 2007 0
unable to enter data on form. help? 1
Data entry for a table from a form 2
Can't enter data in Subform 6
Using an append query in a subform 1

Back
Top