Need to open a form and navigate to record on subform's subform

[keun]

I have a form with a subform, and another subform in that subform.

The main form is Client. The first subform is matter (clients have more than one matter). The nested subform is project. (matters have more than one project.

I have a lookup form, which allows users to apply a bunch of filters to find projects. The form shows client, matter, and project info. What I want to do is to make a double-click open the main form, but navigated to the project nested subform.

I can get the event to open the main form and nav to the proper client, but the matters and projects are a mystery to me.

Private Sub Project_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "Main", , , "[clientname] =  """ & Me.Client & """"
End Sub

 

[Remou]

Try:

Dim frm As Form
Set frm = Forms![MainFormName].Form![SubFormControlName#1].Form
frm.[SubFormControlName#2].SetFocus
frm.[SubFormControlName#2].Form![ControlName].SetFocus

From:

http://www.tek-tips.com/viewthread.cfm?qid=1542326

http://lessthandot.com

 

[keun]

I will try that. Here is where I am unclear - how does this navigate to the appropriate record? It looks like it just sets focus on a field.

 

[Remou]

I was unclear on where you were having problems.

Set rs=frm.[SubFormControlName#2].Form.RecordsetClone
rs.FindFirst "SomeNumericField=" & SomeNumercVar

http://lessthandot.com