I am struggling to refresh a subform.
I have a main form that is a popup, called frmBOC. I click a button on frmBOC to open another data entry form that fills in data on a subform (frmsubBOC), on frmBOC. This is also a popup form, called frmADD.
When I close frmADD I would like the subform to requery or refresh to show the new line.
I have tried all sorts of variations in the on activate, and on get focus events of frmBOC and none of them work. All I can do is use F5 or F9 to update the subform.
Thanks for any advice.