Can't get total field in form to update
Posted on 2011-09-02
Great Day, I have a form that calculates service items performed by a technician. Each time the user enters a service item and and associated cost or if he/she edits an existing cost, I want txtRepairTotal to update, but this does not happen until I move away from the record and then return. I have Do.Cmd.Requery "txtRepairTotal" in the AfterUpdate event, but it is not giving me the expected results. There is no change to txtRepairTotal.
Thanks in advance for your assistance,