OpenForm to record in a Subform

[atticus1802]

Good Evening,

I have looked everywhere for an answer to this so I am hoping I haven't missed this. I want to link to a specific record in a subform. I originally used the below piece of VBA code, which looked at the "Main_Contact" record from my main form which is named "frmProject", and brought back the correpsonding record in the "frmContacts" form.

Private Sub Find_Main_Button_Click()
DoCmd.OpenForm "frmContacts", , , "Contact_Full_Name = '" & Me.Main_Contact & "'"
End Sub

I have since changed this so that the "frmcontacts" form is now a subform in the "frmLaw_Firms" form. I would like to open the "frmLaw_Firms" form and open the corresponding record in the subform.

I hope this make sense.

Thanks in advance.

 

[Gazza2]

Im no expert but i think you need to change the openform to open your main form first and then use Forms!FormName!Fieldname for the where clause bit.

Gareth