Yes, I tried that on the Load event in the 1st subform - see code below, but it doesn't bring up the newly added record after the 2nd subform closes. Also, on the 1st subform I have set the properties as Filter = Subform's FK; Filter On Load = Yes; Order By = Subform's PK DESC. Not sure why it's not working. Do I need to set the properties back to default so the Me.Requery works?
Code:
Private Sub Form_Load()
Me.Requery
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToLast
End If
Me.cmd_UpdatePFRR.Enabled = False
End Sub