K
kpick4 via AccessMonster.com
Access 2007 Question
I have a master/subform - order/payments. I have the original total amount
due in the master form. I have a calculated sum of the payments in the
subform. I want to calculate the new balance due after each payment and
display it in the master form in real time. Simply put the formula is
TOTAL - PAYMENTS = BALANCE_DUE with TOTAL being a stored value from the
database and PAYMENTS being calculated in a subform and passed to the main
form and BALANCE_DUE being the resultant calculated value. When I close and
reopen the form the BALANCE_DUE calc is performed. I want to make it happen
in real time.
The control source for PAYMENTS is DSum ["PAYMENT","PAYMENTS",
"ORDNUM="&ordnum)
I tried using he After Update trigger for PAYMENT, using the expression Forms!
[orderform]![PAYMENTS_MADE] =DSum("PAYMENT","PAYMENTS","ORDNUM=" & [ORDNUM]),
without success.
I know this should be really simple.... Thanks in advance for any help.
I have a master/subform - order/payments. I have the original total amount
due in the master form. I have a calculated sum of the payments in the
subform. I want to calculate the new balance due after each payment and
display it in the master form in real time. Simply put the formula is
TOTAL - PAYMENTS = BALANCE_DUE with TOTAL being a stored value from the
database and PAYMENTS being calculated in a subform and passed to the main
form and BALANCE_DUE being the resultant calculated value. When I close and
reopen the form the BALANCE_DUE calc is performed. I want to make it happen
in real time.
The control source for PAYMENTS is DSum ["PAYMENT","PAYMENTS",
"ORDNUM="&ordnum)
I tried using he After Update trigger for PAYMENT, using the expression Forms!
[orderform]![PAYMENTS_MADE] =DSum("PAYMENT","PAYMENTS","ORDNUM=" & [ORDNUM]),
without success.
I know this should be really simple.... Thanks in advance for any help.