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.

Apples

<tbody>
</tbody>

Order date	product ID	Product name	Purchased quantity	Movement type	Running Balance
9/23/2017	12	Apples	12	Purchased	12
9/24/2017	12	Apples	9	Transferred	3
9/25/2017	12	Apples	2	Transferred	1

<tbody>
</tbody>

 

[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