Update / Refresh as sub form

  • Thread starter Thread starter Sohaib Elahi via AccessMonster.com
  • Start date Start date
S

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.
 
Sohaib Elahi via AccessMonster.com said:
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.
Click to expand...

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

DoCmd.Requery Forms!YourMainForm!YourSecondSubform
 
Back
Top