chrisjames25
Registered User.
- Local time
- Today, 12:52
- Joined
- Dec 1, 2014
- Messages
- 401
Hi. PReviously you guys have assisted me in requering a subform in a loaded form when i close another form. Works great.
For example i have MainForm with a SubMainform which lists different products. On the mainform there is an add button that pops up another form - AddForm.
When i close add form the following code is triggered on the addform:
Then within the main form there is the following code:
This requeries my list in subform and the world is happy - until now.
I now have the situation where i have a:
Mainform
SubMainform
Sub-Submainform
My question is, how do i adapt my code to requery the sub-subform when i close the Addform.
Cheers in advance
For example i have MainForm with a SubMainform which lists different products. On the mainform there is an add button that pops up another form - AddForm.
When i close add form the following code is triggered on the addform:
Code:
Private Sub Form_Close()
Const FN As String = "Mainform"
If CurrentProject.AllForms(FN).IsLoaded Then Forms(FN).RequerySubforms
End Sub
Then within the main form there is the following code:
Code:
Public Sub RequerySubforms()
Me.Child43.Requery
End Sub
This requeries my list in subform and the world is happy - until now.
I now have the situation where i have a:
Mainform
SubMainform
Sub-Submainform
My question is, how do i adapt my code to requery the sub-subform when i close the Addform.
Cheers in advance