Open form and show specific record in subform

[brother]

Hi,

I have a form named Form1 with a subform Form2.
How can I open Form1 from another form and find a specific record in the subform?

This code only filters by customer, and not project like I want it to.

docmd.OpenForm "FrmProject",,,"[CustomerID]=forms![FrmMain].form![CustomerID]"

Hope that was not too confusing

Thanks!

 

[HiTechCoach]

On eoption would be to pass the record id as an OpenArg parameter.

In the Form's On Load event, check for the OpenArg. If found, then select that record in the sub form.

 

[brother]

Thanks HiTechCoach!

To anyone who is looking for the same thing, here is my solution:

The button btnProject on FrmMain has the following Event:

docmd.OpenForm "FrmProject",,,"[CustomerID]=forms![FrmMain].form![CustomerID]",,[ProjectID]

In the OnLoad event of FrmProject I have written this code:

Private Sub Form_Load()
If Not IsNull(Me.OpenArgs) Then
Me.FrmProjectSub.SetFocus
Me.FrmProjectSub.Form!ProjectID.SetFocus
DoCmd.FindRecord Me.OpenArgs
End If
End Sub

 

[HiTechCoach]

brother,

Great job!

Glad we could assist.

Thanks for posting your solution so many other can benefit!