D
David Ehrenreich
I would like to requery a subform from another form. I
have forms in two seperate mdf files, and tables in another
(Frm1, Frm2) and i need frm1 to requery form 2 when it is
closed. I have tried this method but only works when the
form is in the same file.
Private Sub Form_AfterUpdate()
If CurrentProject.AllForms("frm2").IsLoaded Then
Forms![frm2]![frm2Sbfrm.Requery
End If
End Sub
I was wondering if currentProject has something to do with
it?
Any help would be great.
Thank you
David Ehrenreich
have forms in two seperate mdf files, and tables in another
(Frm1, Frm2) and i need frm1 to requery form 2 when it is
closed. I have tried this method but only works when the
form is in the same file.
Private Sub Form_AfterUpdate()
If CurrentProject.AllForms("frm2").IsLoaded Then
Forms![frm2]![frm2Sbfrm.Requery
End If
End Sub
I was wondering if currentProject has something to do with
it?
Any help would be great.
Thank you
David Ehrenreich