I have a form with sub forms . Each sub form has a textboxes getting me a total value of a field. In the main form I want to add a textboxes that will sum up values in the textboxes of the subforms. Help!
You shouldn't store an on hand quantity, you should always calculate it.
And you are storing Stock In and Stock Out as separate items - again they should be in the same column - Positive values In - Negative values Out.