Running Balance Question

[bradyman97]

I have a Form that has a combo box with a sub form in it. When I select a item in the combo box the item history shows up in the sub form. My question is how can I get a running balance in my sub form? Below is what my Form looks like without the running Balance column.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Apples[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 500"]
<tbody>[TR]
[TD]Order date[/TD]
[TD]product ID[/TD]
[TD]Product name[/TD]
[TD]Purchased quantity[/TD]
[TD]Movement type[/TD]
[TD]Running Balance[/TD]
[/TR]
[TR]
[TD]9/23/2017[/TD]
[TD]12[/TD]
[TD]Apples[/TD]
[TD]12[/TD]
[TD]Purchased[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]9/24/2017[/TD]
[TD]12[/TD]
[TD]Apples[/TD]
[TD]9[/TD]
[TD]Transferred[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]9/25/2017[/TD]
[TD]12[/TD]
[TD]Apples[/TD]
[TD]2[/TD]
[TD]Transferred[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

it cannot be done in a form (naturally), but it CAN in a report.
add the amt field, set the property RUNNING SUM = true

Tho, heres a link to use vb code to get a running sum in a form
http://www.tek-tips.com/faqs.cfm?fid=5248

 

[bradyman97]

Ok Thank you