How do I update a total on a subform after entry?

[Belinda7237]

I have created a form for data entry as users will be doing a quality
inspection and the form that has been created uses combo boxes for them to
record if the items are correct or not. (Yes, No, NA). I used tabs to make
it easier to view on the form as there were a ton of fields to complete. I
had to use two tables to store the data, thus had to insert subforms to add
all of the required fields to the tabs.
My final tab of the form includes a summary of all of the items that are
correct, and not correct by tab. (I have the yes and No responses translate
into numbers).
This summary totals the fields using a select query that feeds into the
summary tab.
The issue I have is that for my summary to total correctly, I have to
advance to record 2, and then when i go back to record 1 the summary totals
are populated correctly. How do i get the summary to populate without having
to advance the record and then go back?

 

[Beetle]

You need to requery the recordsource of your from or subform. I can't tell
you exactly where to do this because I don't know anything about your setup,
but
it can be done several different ways, i.e in the after update event of a form
or control, the click event of a button, etc. To do the requery you use
something
like;

MyForm.Requery

or if it's a subform;

MyForm!MySubformControl.Form.Requery