C
ChuckW
Hi,
I have a main form with two subforms. In the subform I have combo boxes
that allow users to select items from an item list. The subform is continous
and adds another combo box each time another item is selected. I also have a
text box to the right of the combo box which is QTY. A user will normally
select about four or five items and then plug in a Quantity for each one. I
have also created another subform which totals the values of all items
selected in the subform. This works fine except when a quantity is changed.
For instance if I have select four items with a quantity of 20, the subform
below which totals it will list 80. If I change the first value to say 15,
the value in the totals subform remains at 80. If I close the subform and
then reopen it, it will update it to 75. I would like something such as a
button that will allow me to refresh the total in the totals subform if I
change one of the quantities above. Can someone help?
Thanks,
I have a main form with two subforms. In the subform I have combo boxes
that allow users to select items from an item list. The subform is continous
and adds another combo box each time another item is selected. I also have a
text box to the right of the combo box which is QTY. A user will normally
select about four or five items and then plug in a Quantity for each one. I
have also created another subform which totals the values of all items
selected in the subform. This works fine except when a quantity is changed.
For instance if I have select four items with a quantity of 20, the subform
below which totals it will list 80. If I change the first value to say 15,
the value in the totals subform remains at 80. If I close the subform and
then reopen it, it will update it to 75. I would like something such as a
button that will allow me to refresh the total in the totals subform if I
change one of the quantities above. Can someone help?
Thanks,