Value of Subtotal from Subform Changes

[GregShah]

I am calculating a subtotal from a series of number on a subform and then including the total on my form. When I initially enter my data in the sub form, the total number shown on the main form is not correct. However, once I close the form, open the table where the data resides and then reopen the form/subform, the subtotal is correct.

The whole purpose of the subtotal is to validate the data entry into the subform so it is important that this subtotal be correctly displayed during the data entry if possible.



Has anyone experienced this type of issue calculating a subtotal from a subform.

Thanks,

GregShah

[ranman256]

in the subform footer, put a field where =SUM([field])
now your total will instantaneously update with the subform values.

you can reference it from the main form too.

[GregShah]

I created a calculation and placed it into the footer of the subform. I referenced it properly in the main form and it does disply a number in the main form. The problem is that it does not update the total instantaneously. The total is wrong at first. Once I close the form and then reopen it, the field it then correct.

The subtotal is not "current" for lack of a better term. However, once I reopen, the figure is accurate.

Thanks,

Greg

[ranman256]

mine is immediate.

you could put a button to refreesh...
[Forms]![frmDetail]![Child11].[Form]![txtSum].Requery

[June7]

The total will recalculate after new subform record is committed to table. Record is committed when moving to another record, closing form, or running code to save.