Text box question??

[Accessme2]

I have a textbox that is use to enter a qty of items that has been completed there are three other text boxes ; the qty needed, the qty still needed and the last one that calculate if there were more items made.

My question is, on the one that I use to put how many items are been made; I want to be able to enter a number add the number that is already there but It seems like I am going blank can not make it work.
eg;
QTY QTY COMPL STILL NEEDED REMAKES
10 2 8 0

So if I enter 5 where the 2 is I want to change to 7 I have code on the after update that will change the "STILL NEEDED" AND "REMAKES"

I would appreciated any help.

 

[SOS]

You should be able to have a control with a control source like this:

=Nz([Qty],0) - Nz([Qty Completed],0)

change the items in the square brackets to your actual control names. If the controls are named the same as the fields you may get #Name as an error message. If so, change the control names to something like txtQty and txtQtyCompleted and then use those names in the formula.

This data should not be stored in the table but just for viewing.

 

[Accessme2]

but how can I click on a text box that have already a qty like 2 and if I go back and I enter 5 i want to display 7 on the same text box.
so lets said I have only one text box that i want to enter a number and I want to add it to the number that is already there.

 

[SOS]

In the control's After Update event put this:

Me.ControlName = Me.ControlName + Me.ControlName.OldValue

 

[Accessme2]

SOS thank you very much .oldvalue ahgggg
need to hit the books.
I really appreciate the help..

 

[SOS]

Glad I could help. I had to try that one out myself to make sure it wouldn't get stuck in a perpetual loop or something. It actually surprised me to see it didn't. Good luck with the rest of your project.