I have data bound to controls are Jan, Feb etc. That are in my main table which is tblProducts.
tblProducts will have users enter amounts for certain products where the totals for those products cannot change from current month forward - only previous months. It is like an inventory tracking where the total inventory cannot change for previous months but how the amount is split up between the previous months can change.
I can split the 1000 up between Jan and Feb but my total has to be 1000 still or 2000 total. I am just trying to make it a little clearer.
J an Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec
Total 1000 1000
Red 1000
White 1000
Blue
How can I accomplhish this? This is a subform based on a main form where there is a create date and revised date entered when a record for the product is created or updated.
tblProducts will have users enter amounts for certain products where the totals for those products cannot change from current month forward - only previous months. It is like an inventory tracking where the total inventory cannot change for previous months but how the amount is split up between the previous months can change.
I can split the 1000 up between Jan and Feb but my total has to be 1000 still or 2000 total. I am just trying to make it a little clearer.
J an Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec
Total 1000 1000
Red 1000
White 1000
Blue
How can I accomplhish this? This is a subform based on a main form where there is a create date and revised date entered when a record for the product is created or updated.
