Purchase Order Totals

[ChipVerdi55]

I have a Purchase Order form with a a subform that has POline item details (ProductID, Quantity, Unit Cost, and extended Cost (calculated). I want to sum the list of ExtendedCosts which are on a subform to display total PO cost. I also want that sum toupdate as I add line items.
My PO main form is 90% similar to Northwinds Order DetailsForm which allows the user to add items to a Purchase Order. However Northwindsdoes not sum the extended costs to display the total Purchase Order costs.


I have tried two things
1. Ieither get a #error if I try to do the sum in a text box on the main form, or
2. WhenI wrote a query to use on a second subform which had a single field whichdisplayed the PO total, I got the total costs but I can’t get the total toupdate either when a new line item extended costs are calculated or when I makea change in one of the PO Line Items. I tried the following with limitedsuccess

 Private Sub Form_AfterUpdate()

   Me.Parent!POTotalChild28.Form.Requery
End Sub 

Now the subform will update to thecorrect total if I change records or place focus on the main form. The user prefersto see the new total immediately.
Any ideas?

[June7]

Is the subform in Datasheet or Continuous View?

If Continuous view, try textboxes in Report footer with expressions to sum fields.

If Datasheet view, open form (not in Design view), click the Totals button on ribbon. This will reveal a Totals row. Select the desired function under each field. Click Save button.

Want to provide db for analysis? Follow instructions at bottom of my post.

[ChipVerdi55]

I followed your directions and summed the Extended Cost field. Thanks for that tip. However, after a change to either the quantity or cost fields in an individual record, I had to change records to get the total to recalculate.

[June7]

Yes, that is likely because data entry/edit is not committed until form closes, move to another record, or run code.