Unanswered: Checking a "sum()" field is updated before checking it?
Hi. I've got a form with a subform in it. The subform shows multiple records (continuous), has a field called "amount", and at the bottom a textbox that is =sum([Amount]). All I want is when closing the form that it checks the sum([Amount]) field.
Problem is, if I am updating a record, the sum box only updates after I click away from that record and it updates the record. If I close the form while the record is still "dirty", the sum box hasn't updated yet.
i have tried "Me!AllocationsSubform.Form.Dirty = False", but it still doesn't refresh the sum box.