I'm trying to requery a subform two levels down from an onclose even on a popup form.
the rest of the onclose event is in a macro.
I would like it to be in vba, but for some reason my settempvars isn't working in vba, so i'm stuck with a macro. (will be another question)
So for now, i'm using the macro to 'run code' ie. call a function in which I am trying to do the requery.
from ms help "
If you want to requery a control that isn't on the active object, you must use the Requery method in a Visual Basic for Applications (VBA) module, not the Requery action or its corresponding Requery method of the DoCmd object. "
parent form : frmmain - view normal
subform 1 : frmtallysheetlist - view normal
subfrom 2 : sbfrmtallysheetlist - view datasheet
popupform : frmtallysheetcreator
the event is triggered on the onclose event of the popup form.
subform 2 is a subform of subform 1 which is a subform of frmmain.
subform 2 's recordsource is a query.
My code below did not work.
On Error GoTo refresh_Err