<div>
Depends on where your coding takes place. Let's imagine it's the main form:<br />
<br />
&nbsp; &nbsp; Me.subControlName.SetFocus<wbr /><br />
&nbsp; &nbsp; Me.subControlName.Form.sub<wbr />SubControl<wbr />Name.SetFo<wbr />cus<br />
&nbsp; &nbsp; Me.subControlName.Form.sub<wbr />SubControl<wbr />Name.Form.<wbr />ControlNam<wbr />e.SetFocus<wbr /><br />
<br />
(°v°)
</div>


Depends on where your coding takes place. Let's imagine it's the main form:

    Me.subControlName.SetFocus
    Me.subControlName.Form.subSubControlName.SetFocus
    Me.subControlName.Form.subSubControlName.Form.ControlName.SetFocus

(°v°)

<div>
I guess that is the issue.... I don't know where the user is when the macro is executed.
</div>


I guess that is the issue.... I don't know where the user is when the macro is executed.

<div>
It isn't. The question is only from where the code will be run. If it's a macro, your safest bet is to fully specify everything. Replace Me. with the full reference Forms!frmYourMainForm. and you will be ok.<br />
<br />
(°v°)
</div>


It isn't. The question is only from where the code will be run. If it's a macro, your safest bet is to fully specify everything. Replace Me. with the full reference Forms!frmYourMainForm. and you will be ok.

(°v°)

<div>
OK, but I&quot;m not using VB but rahter the Macro gui... is your solution possible?
</div>


OK, but I"m not using VB but rahter the Macro gui... is your solution possible?

<div>
<div class="content wysiwyg-content">
I have a form that contains a sub form which contains another subform. &nbsp;I need to get focus to a particular field on the 2nd sub form. &nbsp;The user could be any where in the main form, sub form or the sub-sub form. &nbsp;<br />
<br />
How can I code in a way to get to a text box in the sub-sub-form? &nbsp;I know there is me and me.parent (??) but it isn't always working depending on where the user is when the present code is executed.<br />
<br />
Thank you.
</div>
</div>


I have a form that contains a sub form which contains another subform.  I need to get focus to a particular field on the 2nd sub form.  The user could be any where in the main form, sub form or the sub-sub form.  

How can I code in a way to get to a text box in the sub-sub-form?  I know there is me and me.parent (??) but it isn't always working depending on where the user is when the present code is executed.

Thank you.

How do get focus to a particular field

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.