Hi
I have two sub forms in a main form...
A Candidate Single Form
A Candidate Datasheet Form
When a new record is entered or an existing record is updated in either of the sub forms, I'd like the other sub form to immediately refresh to show the new record or changes.
I've tried these...
In the Datasheet Form in AfterUpdate, AfterInsert
and
In the Single Form in AfterUpdate, AfterInsert
but neither of them are refreshing the form as it does when I select the Sub Form and click refresh from the toolbar.
I have two sub forms in a main form...
A Candidate Single Form
A Candidate Datasheet Form
When a new record is entered or an existing record is updated in either of the sub forms, I'd like the other sub form to immediately refresh to show the new record or changes.
I've tried these...
In the Datasheet Form in AfterUpdate, AfterInsert
Code:
Forms![frm_RRAR]![subfrm_Candidates].Form.Requery
and
In the Single Form in AfterUpdate, AfterInsert
Code:
Forms![frm_RRAR]![ds_subfrm_Candidates].Form.Requery
but neither of them are refreshing the form as it does when I select the Sub Form and click refresh from the toolbar.