S
Skunk
HI...Can I do this?
A form [2frmDEInvoiceCreditApply] has an unbound combo box to lookup return
a record to populate controls on a subform of that form. Works great, use
column(x) for retrieving.
On the subform:
I am attempting to calculate a balance due as follows:
CreditAmount: from Column(2) of the combo box on the parent form, the
original gross credit amount.
CreditApplied: =Nz(DSum("[AppAmount]","[tbl 1 ClientCreditApplied]","[tbl 1
ClientCreditApplied]![AppInvNum]=
Forms![2frmDEInvoiceCreditApply]![cboInvNum]")) -- the sum of all amounts
applied.
CreditBalance: CreditAmount-CreditApplied. That amount still available to
apply.
My problem is with DSum. I use it frequently, but this is giving me fits.
CreditApplied is always blank; I cannot retrieve/sum the value. Using the
populated (via combo box column(2) control on the subform fails so I thought
the column might not be workable. Should it be?
What can I do to retrieve and sum all the applied amounts tied to the
invoice number in the combo box/subform control as populated?
Any help . . .
A form [2frmDEInvoiceCreditApply] has an unbound combo box to lookup return
a record to populate controls on a subform of that form. Works great, use
column(x) for retrieving.
On the subform:
I am attempting to calculate a balance due as follows:
CreditAmount: from Column(2) of the combo box on the parent form, the
original gross credit amount.
CreditApplied: =Nz(DSum("[AppAmount]","[tbl 1 ClientCreditApplied]","[tbl 1
ClientCreditApplied]![AppInvNum]=
Forms![2frmDEInvoiceCreditApply]![cboInvNum]")) -- the sum of all amounts
applied.
CreditBalance: CreditAmount-CreditApplied. That amount still available to
apply.
My problem is with DSum. I use it frequently, but this is giving me fits.
CreditApplied is always blank; I cannot retrieve/sum the value. Using the
populated (via combo box column(2) control on the subform fails so I thought
the column might not be workable. Should it be?
What can I do to retrieve and sum all the applied amounts tied to the
invoice number in the combo box/subform control as populated?
Any help . . .