Auto populate a row in a subform based on a remaining amount
Hi,
I have been trying to figure out how to make a row auto populate into a continuous SubForm.
What i am dealing with is this,
the Continuous form is basically a list of active ingredients with the appropriate dose needed of that active ingredient next to it.
before the list is filled with Active ingredients a target dose amount is set for the batch. Most of the time the active ingredient dose will fall short of the target dose amount by 50 or so. The thing is that the remaining weight has to be filled with a cheap filler ingredient so that the total batch comes out at the right dose. (I hope i am making sense here)
basically,
Total/Target dose amount set to -- 800
Active Ingredients list:
Ingredient1 -- 100
Ingredient2 -- 100
Ingredient3 -- 100
Ingredient5 -- 100
Ingredient6 -- 250
TOTAL Actives ----650
(take the difference of the target dose minus the total actives dose and you have the amount of filler to add to the list. )
Dose Remainder = 150 ( this is what needs to be auto added to the list with that dose amount,150)
I'm not sure if its doable because i have been trying to figure it out for like three days.
you guys are my last hope...
Hi,
I have been trying to figure out how to make a row auto populate into a continuous SubForm.
What i am dealing with is this,
the Continuous form is basically a list of active ingredients with the appropriate dose needed of that active ingredient next to it.
before the list is filled with Active ingredients a target dose amount is set for the batch. Most of the time the active ingredient dose will fall short of the target dose amount by 50 or so. The thing is that the remaining weight has to be filled with a cheap filler ingredient so that the total batch comes out at the right dose. (I hope i am making sense here)
basically,
Total/Target dose amount set to -- 800
Active Ingredients list:
Ingredient1 -- 100
Ingredient2 -- 100
Ingredient3 -- 100
Ingredient5 -- 100
Ingredient6 -- 250
TOTAL Actives ----650
(take the difference of the target dose minus the total actives dose and you have the amount of filler to add to the list. )
Dose Remainder = 150 ( this is what needs to be auto added to the list with that dose amount,150)
I'm not sure if its doable because i have been trying to figure it out for like three days.
you guys are my last hope...
Last edited: