Refresh subform from a different form (1 Viewer)

[brharrii]

I have an close button on a form that is supposed to Refresh the subform of a different form and then close the form with the close button.

frmOperations - no refresh / requery
subfrmPlants - Needs to be refreshed / requeried

frmPlants - Needs to be closed

Currently the button effectively closes frmPlants, but it's failing to refresh the data on my subform to display any changes that have been made on frmPlants.

can anyone tell what I'm doing wrong? I've tried with refresh and requery, neither seem to work.

Private Sub lblClose_Click()
    If CurrentProject.AllForms("frmOperations").IsLoaded Then
        Forms!frmOperations!subfrmPlants.Form.Refresh
    End If
 
    DoCmd.Close acForm, "frmPlants", acSavePrompt
End Sub

Thanks!

 

[ByteMyzer]

Try changing the highlighted code:

Private Sub lblClose_Click()
    If CurrentProject.AllForms("frmOperations").IsLoaded Then
        Forms!frmOperations!subfrmPlants.Form.[B][I][COLOR="Red"]Requery[/COLOR][/I][/B]
    End If
 
    DoCmd.Close acForm, "frmPlants", acSavePrompt
End Sub

 

[brharrii]

I thought I had tried that.... but apparently i had made another tweek between trying refresh and requery as well. That worked perfectly.

Thank you!