Requery forms closed error

raphael99

Registered User.
Local time
Today, 05:06
Joined
Apr 6, 2015
Messages
126
Hi. I have one form (FRMPIP) which has a button to save data and requery 2 forms
Code:
Forms![FRMMesePrecedentePIP].[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Form.Requery

Forms![FRMMeseCorrentePIP].[FRMSottomaschera QueryPIPMeseCorrenteConcatRelated].Form.Requery
The two lines of code requery two different subforms located on two different mainform.
All is working fine if the both mainform including subform are opens.
If one or the other mainform is closed I get error "impossible to find form "nameform".
Is there a way to bypass this obstacle?
Thanks
 
Solved:

Code:
If CurrentProject.AllForms("FRMMeseCorrentePIP").IsLoaded Then
Forms![FRMMeseCorrentePIP].[FRMSottomaschera QueryPIPMeseCorrenteConcatRelated].Form.Requery
End If

If CurrentProject.AllForms("FRMMesePrecedentePIP").IsLoaded Then
Forms!FRMMesePrecedentePIP.[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Requery
End If
 

Users who are viewing this thread

Back
Top Bottom