Getting sub forms to reflect new data after updating

[DJH]

How do I get subform #2 to reflect updated data from subform #1?
When I update #1, #2 stills shows same data as when the form was open.

Thanks in advance....

 

[John Vinson]

How do I get subform #2 to reflect updated data from subform #1?
When I update #1, #2 stills shows same data as when the form was open.

Thanks in advance....

What are the Recordsources of these two subforms? How does updating #1
change the values in #2?

You may be able to do what you want with code like this in the
AfterUpdate event of the Form in subform 1. I'm assuming that the
second subform is in a Subform control named subMySub2 (the Name
property of the container, the Subform Control, is what's needed, not
the name of the form within that control):

Private Sub Form_AfterUpdate()
Parent!subMySub2.Requery
End Sub

This will requery the second subform displaying all of the records
which (now) qualify for display.

John W. Vinson[MVP]