Keeping a running total of a text box...

  • Thread starter Rashar Sharro via AccessMonster.com
  • Start date
R

Rashar Sharro via AccessMonster.com

Hi,

I have a sub form with one text box, and when my qurey runs, it creates 25
textboxes for the end user to enter a quantity.

Here is the Code...

lngQuantity_This = Forms!mainForm!sfrm1!sfrm2!Quantity_This + IIf(Nz
(Quantity_This, 0) > lngQuantity_This_OldValue, Nz(Quantity_This -
lngQuantity_This_OldValue, 0), -(lngQuantity_This_OldValue - Nz(Quantity_This,
0)))

What I would like to do is keep a running total in Forms!mainForm!sfrm1!sfrm2!
Quantity_This...

Any help would be greatly appreciated.

Thanks,

Robert
 
Top