Copying Fields

[sha123]

I have a form called ToolBookOut, in the form there is a few fields, 1)Current Stock 2)Quantity 3)New Stock Level

How this form works is when you add a value in quantity it deducts the value from current stock and put it in the new stock level!

I now need to get the form to carry the value from New Stock Level to to the next record on that form and put the value in current stock! How will I do That?

 

[JimYellow]

Create a local variable

set the variable
move record (acNext)
then copy the value to the field from the variable