<div>
Hi Mach1pro,<br />
How about Controls(i+3).setfocus<br />
<br />
Good Luck!<br />
<br />
Gary
</div>


Hi Mach1pro,
How about Controls(i+3).setfocus

Good Luck!

Gary

<div>
tbsgadi <br />
Your code would set the focus to the next control in the control indexes, not the next tabIndex. 
</div>


tbsgadi
Your code would set the focus to the next control in the control indexes, not the next tabIndex.

<div>
You might want to check for TabStop being set to true also and count on only if that is met.<br />
<br />
That would involve iterating through the controls at least three times!<br />
<br />
But if you're sure it won't be then yep - Dave's way is the way.
</div>


You might want to check for TabStop being set to true also and count on only if that is met.

That would involve iterating through the controls at least three times!

But if you're sure it won't be then yep - Dave's way is the way.

<div>
<div class="content wysiwyg-content">
I know the name of the control in a form &nbsp;and can retrieve the tabIndex. &nbsp;eg. &nbsp;i = Controls(&quot;name of control&quot;).TabIndex<br />
How can I set the focus to a specific control using the tabindex? For example I want to set focus to &nbsp;i + 3<br />

</div>
</div>


I know the name of the control in a form  and can retrieve the tabIndex.  eg.  i = Controls("name of control").TabIndex
How can I set the focus to a specific control using the tabindex? For example I want to set focus to  i + 3


How to go to a specific TabIndexed control

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.