<div>
You have to be sure you refer to the Subform Control correctly. From the first Subform:<br />
<br />
Me.Parent.SecondSubformCON<wbr />TROL.Form.<wbr />NameOfCont<wbr />rolOnForm.<wbr />SetFocus<br />
<br />
Be careful with the name of the Subform CONTROL. It's the name of the Control on your parent form, and may or may not be named the same as the form that you're using as a Subform.
</div>


You have to be sure you refer to the Subform Control correctly. From the first Subform:

Me.Parent.SecondSubformCONTROL.Form.NameOfControlOnForm.SetFocus

Be careful with the name of the Subform CONTROL. It's the name of the Control on your parent form, and may or may not be named the same as the form that you're using as a Subform.

<div>
Seems I do have to set focus on the 2nd sub-form first. &nbsp;Thanks.
</div>


Seems I do have to set focus on the 2nd sub-form first.  Thanks.

<div>
<div class="content wysiwyg-content">
I have a main form with 2 datasheet sub-forms. &nbsp;On the 1st sub-form, if the user leaves the first field in a new record empty, when they tab off of it I want the cursor to go to the 2nd sub-forms 1st field.<br />
<br />
<br />
I have tried these and they don't work:<br />
<br />
<br />

<pre><code id="code-10-29104065-1">Private Sub cbo1stForm1stCombobox_LostFocus()

    If IsNull(Me.cbo1stForm1stCombobox) Then
        
'        Forms!frmMainForm!frm2ndSubForm.Form!cbo1stField.SetFocus
   
'        Me.Parent.Form!frm1stSubForm.Form.cbo1stField.SetFocus

'        Me.Parent!frm2ndSubForm.Form.cbo1stField.SetFocus
        
'        Forms!frm2ndSubForm.Form.cbo1stField.SetFocus
        
    End If

End Sub</code></pre>
</div>
</div>


I have a main form with 2 datasheet sub-forms.  On the 1st sub-form, if the user leaves the first field in a new record empty, when they tab off of it I want the cursor to go to the 2nd sub-forms 1st field.


I have tried these and they don't work:


(CODE)

How tab to 1st field on next sub-form

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.