Getting sub forms to reflect new data after updating

  • Thread starter Thread starter DJH
  • Start date Start date
D

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....
 
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....
Click to expand...

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]
 
Back
Top