how to requery a subform after a record added in another subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings all,

I have a main form (frmClients) with two subforms (subVisits)
(subAccount). I got the subforms to reflect what the main form is
showing by linking master and child fields (I think--newbie here). Now
I need the second subform (subAccount) to update when I add a visit in
the subVisits subform. I assume that the AfterUpdate would do it, but
I cant figure out what the code is to update another subform would be.
Not Me.Requery but I assume something like it. Any assistance?


Thanks in advance.


DB
 
Assuming that subVisits and subAccount a getting records from different
tables, it should not be necessary to requery, but something like this
should do it:

Private Sub Form_AfterUpdate()
Me.Parent![subAccount].Form.Requery
End Sub
 
Back
Top