Update / Refresh as sub form

[Sohaib Elahi via AccessMonster.com]

I have a Main Form, having two subforms side by side with common linked
field. Both the subforms use the same data table.
First subform is used for data entry in single form view.
Other subform is used for data view in countineous form view.
The problem is that after adding a new record through the first subform,
the second subform is not being updated / refreshed. Although when I
navigate into the Main form, the second subform becomes updated/refresh.
While I want to get update/refresh the subform After Update / After Add new
record.
I will be pleased for help in this problem.

 

[Guest]

I have a Main Form, having two subforms side by side with common linked
field. Both the subforms use the same data table.
First subform is used for data entry in single form view.
Other subform is used for data view in countineous form view.
The problem is that after adding a new record through the first subform,
the second subform is not being updated / refreshed. Although when I
navigate into the Main form, the second subform becomes updated/refresh.
While I want to get update/refresh the subform After Update / After Add new
record.
I will be pleased for help in this problem.

In the AfterUpdate event of you first subform add code to requery the second.

DoCmd.Requery Forms!YourMainForm!YourSecondSubform