I have a very dumb question that I hope someone can help with.
I have a database which has a lot of forms & subforms, most of which are working fine.
Today I had to do another one, which is the simplest of all. On this form is a text box for TransferCost and in the footer I have another box for TotalTransferCost, using the formula =sum(TransferCost).
My problem is that the Total box in the footer will not update when I change an amount or add a new record until the form is closed and reopened. All the other subforms are working fine - the total updates as soon as I move to the next record (these forms are all set up as continuous forms).
As the total is needed elsewhere on the main form, I do not want to have my clients close the main form just to update a $10 entry!
How can I get the total to update automatically? Most of the other forms need calculations to arrive at a total, this one has only one figure entered in each record.
Suggestions will be gratefully received.