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:
Private Sub Form_Close()
Const FN As String = "Mainform"
If CurrentProject.AllForms(FN).IsLoaded Then Forms(FN).RequerySubforms
Then within the main form there is the following code:
Public Sub RequerySubforms()
This requeries my list in subform and the world is happy - until now.
I now have the situation where i have a:
My question is, how do i adapt my code to requery the sub-subform when i close the Addform.
Cheers in advance