F
FJquestioner
I have a field on a subform called AdvanceAmount. I need it to be a
calculated amount as follows, HOWEVER, I need to be able to manually override
the calculation. In either case, the underlying table record needs to be
filled in.
AdvanceAmount =
InvoiceAmount*(IIf(Advance_Percent<Debtors_AdvanceRate,Advance_Percent,Debtors_AdvanceRate)-AllowableDiscountPct)
All the above form fields are in the same subform as AdvanceAmount, except
Advance_Percent which is located in the main form.
I gather that to achieve my objective I need to code an AfterUpdate Event
Procedure for the component fields of the above formula but I'm not sure how
to do that. Could anyone give me the code required for each of the component
fields please ??
Thanks very much.
calculated amount as follows, HOWEVER, I need to be able to manually override
the calculation. In either case, the underlying table record needs to be
filled in.
AdvanceAmount =
InvoiceAmount*(IIf(Advance_Percent<Debtors_AdvanceRate,Advance_Percent,Debtors_AdvanceRate)-AllowableDiscountPct)
All the above form fields are in the same subform as AdvanceAmount, except
Advance_Percent which is located in the main form.
I gather that to achieve my objective I need to code an AfterUpdate Event
Procedure for the component fields of the above formula but I'm not sure how
to do that. Could anyone give me the code required for each of the component
fields please ??
Thanks very much.