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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Unremovable horizontal scroll bar on subform 1
Set Change Event on Control from Nested Subform 0
Subform of subform not being linked 3
First Subform record gets modified when closing form 3
Update records in subform with value from main form 4
Update subform with combobox change on main form 1
Filter on Subform Not Displaying as Expected 1

Back
Top