Is there a way to jump to a new record ..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I am inputting data in the contacts database, I
would like to have it jump to the first field in a new
blank record when I press the enter key after inputting
the third and final field on the current record.

Is there a way to do this? I am relatively new to Access
so you have to dumb down the explanations for me ;-)
 
Under the OnCurrent Event in the form type: me.yourfieldname.setfocus
Each time you move to the next record your cursor will be in that field.
 
When I am inputting data in the contacts database, I
would like to have it jump to the first field in a new
blank record when I press the enter key after inputting
the third and final field on the current record.

Is there a way to do this? I am relatively new to Access
so you have to dumb down the explanations for me ;-)
Click to expand...

Set each control's Tab order as wanted starting with the first control
through the last control.
Then set the Form's Cycle property to All Records. It's on the Form's
Property sheet 'Other' tab.

When you exit the last control, it will go to the first control on the
next record.

You can set the control's Tab order by clicking on the little square
at the left where the 2 rulers meet and selecting Tab Order.
 
Back
Top