I have attached the sample file.
I need away to update query in such away like this:
in form1 i have a subform refer to a query , now i have unbound textbox controls in the main form , i need to fill inside a unbound textboxes:
when i click the fill quantity button it should fill the txtquantity =15 into the quantity field in the subform in such away that 15 will be distributed between the quantity field that are from the type txtPackageType=1000 and txtCurrencyValue=20 on condition that the max quantity for each cell depends on cellcapacity of the record.
if you look at the first line in the subform quary you will see that the quantity=3, which means it reachs the max of the cellcapacity (3*1000=3000)
and the second record has 2000, means it needs to fill in another 1 quantity to reach 3000
and keep going filling each record until filling all .