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

  • Thread starter Thread starter Scotty
  • Start date Start date
S

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
 
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
 
Back
Top