Refresh Subforms (1 Viewer)

music_al

Registered User.
Local time
Today, 06:02
Joined
Nov 23, 2007
Messages
200
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
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.
 

Users who are viewing this thread

Top Bottom