Carrying over a new total figure from previous record to new recor

[Scotty]

I am using a form to calculate existing stock levels. I am trying to carry
over a new quantity figure from one record to the next record so that the new
stock level appears on the next (new) record

 

[Jeanette Cunningham]

Hi Scotty,
you need somewhere to save the stock level.
You can use a hidden form with an unbound text box. Save the new stock level
there, then read it back when the form goes to the next new record.

If you are using a main form, subform setup, you could put an unbound
textbox on the main form and save the stock level in that until you are on
the next new record.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia