updating subform

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I have a form with a subform based on the query. To add items to subform new
form is opened where data is added from the list box. On closing of new form
subform data is updated but the display is not updated. If I will go to
another record on main form and then return the data in the subform is
updated correctly. How I can update it without the need to switch between
records in main form ?

Thanks for suggestions.

Tony
 
Tony you can use the after update of a control on the form or place a button
on your form to requery the subform:

Me.MySubform.Form.Requery
 
Back
Top