H
hacker
Hope someone can help me
I have a Main form with a subform. I enter Total cost on the Maim form. I
enter data into the subform and it includes a subtotal. I have a query that
gives me the remainder after totaling subtotals from subform and subtracting
from Total cost on main form. I have another subform on the main form to
display this remainder. all works fine if i move from one record to another
but cant get remainder to update while entering data on current subfrom.
subform for subtotals is in datasheet view. Is there a way to requery the
remainder subform without leaving the subtotal subform after a subtotal is
entered?
I have a Main form with a subform. I enter Total cost on the Maim form. I
enter data into the subform and it includes a subtotal. I have a query that
gives me the remainder after totaling subtotals from subform and subtracting
from Total cost on main form. I have another subform on the main form to
display this remainder. all works fine if i move from one record to another
but cant get remainder to update while entering data on current subfrom.
subform for subtotals is in datasheet view. Is there a way to requery the
remainder subform without leaving the subtotal subform after a subtotal is
entered?