redrawing a form containing a subform after child records updated

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
 
A

Allen Browne

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