Cell not adding number and remembering last number added

I have a text box titled "txtFallComp" a box titled "txtFallUsed", and one that is titled "txtFallBal". The way I need it to work is that when a number is inputted into "txtFallComp" and "txtFallUsed" is shows the balance in "txtFallBal" which is not a problem. The problem is when I come back to this form to update the "txtFallComp" I need it to update the 'txtFallBal' Instead it deleted the previous numbers and shows the new balance. I have to have the balance show on each record. I know that I can have the operator just add the number in their head for "txtFallComp" and put that in but that opens us up for errors. We do not get all the data at once. It comes in everyday thus has to be updated everyday. Here are the codes I am using.

txtFallComp

Please Login or Register  to view this content.

txtFallBal

Please Login or Register  to view this content.

Fall Balance will never be a negative number. They can only use what they have in the completed box.

Hi Taichi,

Sounds like something is interfering with your "txtFallComp" and "txtFallUsed" textboxes, but there's no real way I can tell without seeing it. You might need to make a form and upload it.

in the meantime, this works for me:

Please Login or Register  to view this content.

AfterUpdate works after the value is updated in the text field.

Cheers

I apologize FDibbins it is an ACCESS database I was using some VBA from an EXCEL spreadsheet that was working and trying to get it to work with this database. Jouneryman3000 thank you for the coding. But when I put a new number in the txtFallComp it still wipes out what is in the txtFallBal and starts over instead of a running addition.

Hi Taichi,

i'm sorry I've not got back to you before now. I think I need to see your form. You should attach a basic file and let me see where the issue lies.

Otherwise it sound like a basic mathematics issue. There are plenty of ways to resolve but if you want to keep a former value for later use, then do something like:

Please Login or Register  to view this content.

A lot depends on the exact nature of your calculation requirements, but running additions require that you hold the form value in memory (or a field) in order to add or subtract to/from it.

Cheers