GoTo Record on a Continuous Subform

[ted.martin]

I have a Mainform F-Jobs; SubForm1 SF-Job Tasks and within this subform is a second subform SF-Job Task Details. This second subform is a continuous form

Within SF-Job Task Details there is a field JobDetailsID

In essence it is
[Forms].[F-Jobs].[SF-Jobs Tasks].Form.[SF-Job Task Details].[Form].[JobDetailsID].value

Depending upon an action on the SubForm1, I want to set the focus to a particular field on SubForm 2 [SF-Job Task Details]

If this was not all happening on a second level subfrom, I would have used DoCmd.SearchForRecord acDataForm etc BUT you cannot use this for a SubForm

As always, I would appreciate any guidance.

 

[ted.martin]

Well after a lot of searching for inspiration, I just went for it and this works.

Dim lngTaskID As Long

Private Sub Form_Open(Cancel As Integer)
    lngTaskID = 0
End Sub

Private Sub TaskDetails_AfterUpdate()

    lngTaskID = JobDetailsID.Value
    Call myRecord
    
End Sub

Private Sub TaskDetailsOrder_AfterUpdate()

    lngTaskID = JobDetailsID.Value
    Call myRecord
    
End Sub

Private Sub myRecord()

    If lngTaskID <> 0 Then
        Me.Requery
        Me.Recordset.FindFirst "JobDetailsID = " & lngTaskID
        TaskDetails.SetFocus
    End If
    
End Sub

Hey Ho. All done from within the SubForm, Smiling Now!