<div>
You need to adjust the controls Tab Order. &nbsp;Not precisely sure how to do it in A2010, but in 2007, you would open the form in design mode. &nbsp;Then select the Arrange tab on the Ribbon and Select Tab Order. &nbsp;Then adjust the sequence of the controls within the section.<br />
<br />
If the current action when it reaches the last control on the form is to jump to the first control on the same record, the you will need to change the FORMs Cycle property (Other tab of the Properties dialog) from &quot;Current Record&quot; to &quot;All REcords&quot;
</div>


You need to adjust the controls Tab Order.  Not precisely sure how to do it in A2010, but in 2007, you would open the form in design mode.  Then select the Arrange tab on the Ribbon and Select Tab Order.  Then adjust the sequence of the controls within the section.

If the current action when it reaches the last control on the form is to jump to the first control on the same record, the you will need to change the FORMs Cycle property (Other tab of the Properties dialog) from "Current Record" to "All REcords"

<div>
This was exactly what I requested. &nbsp;Worked perfectly!
</div>


This was exactly what I requested.  Worked perfectly!

<div>
Disregard, misread the question.
</div>


<div>
<div class="content wysiwyg-content">
In Access 2010 I have a form with the following fields.<br />
TimeStart &nbsp;LunchStart &nbsp;Lunchend &nbsp;TimeEnd &nbsp;PTO &nbsp;Holiday<br />
<br />
If a user presses the Tab Key after entering data in the TimeEnd field, I want the cursor to move to the PTO field. &nbsp;If a user presses the Enter Key after entering data in the TimeEnd field, I want the cursor to move to the Next Record.<br />
<br />
Can anyone help me with this?<br />
<br />
Thanks in advance!
</div>
</div>


In Access 2010 I have a form with the following fields.
TimeStart  LunchStart  Lunchend  TimeEnd  PTO  Holiday

If a user presses the Tab Key after entering data in the TimeEnd field, I want the cursor to move to the PTO field.  If a user presses the Enter Key after entering data in the TimeEnd field, I want the cursor to move to the Next Record.

Can anyone help me with this?

Thanks in advance!

Access VBA Code to move focus when Tab Key or Enter Key is pressed.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.