redrawing a form containing a subform after child records updated

  • Thread starter Thread starter nChicago
  • Start date Start date
N

nChicago

Hi,

Is there a non-VBA way to force a form to redraw a subform's contents after
a new record has been added to the subform's table from a different window?

E.g. I have a form with child records in a subform open. I click an add
child record button. A new form opens where I add a child record. I close
the new form. The original form with the old content in it's subform is now
visible. How do I force an update on the content of the subform?

Thanks.

N
 
Requery the form in the subform control:
Forms![YourMainForm]![YourSubform].Form.Requery
 
Back
Top