Requery from seperate mdf file

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top