refresh popup form

Question

I have a main form that calls a second form(popup).  On the first form, when i change record and call the main form that is still open, it does not update the second form which has a text box that points to a query.  When I click on F5 on my keyboard, it updates the form.  How can i update the second form?

this is the code I have currently.

Private Sub EMAILGUID_DblClick(Cancel As Integer)

...

...

        DoCmd.OpenForm "frm_EmailViewer", acNormal

        Forms![frm_EmailViewer].Form.Refresh

...

...

Answer 1

I'm afraid I don't really understand the setup.

Answer 2

What's strange is that the subform in the second form refreshes but the text box in the second form does not refresh.

Answer 3

didn't work, only refreshes when i hit F5 on my keyboard.

Answer 4

didn't work...still not updating the textbox in the second form.

Answer 5

Perhaps in the On Current event of the main form

Private Sub Form_Current()

    If CurrentProject.AllForms("frm_EmailViewer").IsLoaded Then

        Forms!frm_EmailViewer.Refresh

    End If

End Sub