Close Subform And Display Newly Added Record On Another Subform

[dipitiduda2]

I have a main form with a subform. On the
1st subform I'm opening another subform to add a new record. Once I add the new
record and close the 2nd subform, how do I display the newly added record on the


1st subform. The 1st subform is currently displaying the last record for that
primary id but I can't get it to display the new record I just added. Thanks!

[pbaldy]

Typically you would requery the subform.

[dipitiduda2]

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?

Private Sub Form_Load()
    Me.Requery
    
    If Not Me.NewRecord Then
        RunCommand acCmdRecordsGoToLast
    End If
    
    Me.cmd_UpdatePFRR.Enabled = False
    
End Sub

[pbaldy]

If the 1st remained open, that code does nothing; the load event only runs when the form first loads. The requery is meaningless in that event, since the form is just loading its data anyway. I'd requery it from the code closing the 2nd form.

[dipitiduda2]

Yes, I did that originally and it didn't change anything. I tried it again before the close code in the 2nd subform and it didn't work this time either. Hmm, I'll just keep working on it till I get it. Thanks for your assistance!

[pbaldy]

Can you post the db here?

[dipitiduda2]

Sure, let me scrub the data and I'll post it. Thanks!

[dipitiduda2]

Simply open the dBase, the Navigation form will come up. Click on Adult btn under Manage Programs, click on the PFRRs tab and select any program from the drop down list. Click on the 'add a PFRR...' link to open the 2nd subform and type some data into the form. Click the 'Save PFRR' button. Once the 2nd subform closes the record you just added - see the PK (txtPFRRID) in upper right hand corner of subform and the PK (txtProgramID) of main form - should display in the 1st subform's window.

This is the issue that I can't seem to resolve - the newly added record on the 2nd subform is not being displayed in the 1st subform's window after it's committed to the dBase.

Scrubbed dBase_04152014.zip