AfterUpdate for a subform to a subform

[Neobeowulf]

Team,

I'm trying to figure out how to update a subform based of another subforms update. In the attached database, if you look up the user "Jones" you can see the Customer Items subform and the Weekly Total subform. How do I get the Weekly total subform to update once I edit any of the fields in the customer items subform? If there's a smarter way to get & display these totals, i'm open to ideas.



Additionally, the customer items subform is filtered by week based on the date entered, as is the weekly total subform.

[Neobeowulf]

Okay I figured out a solution. On the subform the inputs are put into, I made a macro in the afterupdate block of the date entered control. From there I just told the macro to OpenForm --> Input Form with the same filter name as the original form [Customer ID]

[Neobeowulf]

Okay that didn't work after all.

[lfpm062010]

Try this code below (textbox "Bulk_Item" in form "Customer Items subform" and "AfterUpdate" event). It will show the current "Bulk Item" count.

Word of caution: The "Refresh" command will auto commit your current record. So, if the record has no date entered, it will be not be displayed. You can only find the record in the table view.

Private Sub Bulk_item_AfterUpdate()
'Forms![InputForm]![Weekly total query subform].Requery
Forms![InputForm].Refresh
End Sub

[Neobeowulf]

Very happy with that result. Mucho gracias for the assist.

I changed it from the bulk item to the date entered. Since the date entered is most likely the last entry of the form, it's perfectly fine that once a date is entered the form commits to record. In the event no date is entered, the save and close button is set to requery the combo box on the main form so the record will show.