Good Day All.
I have a mainform "Invoices Payments" and its subform is "Customer Payments" which has a field also called "customer Payments" which has an event AfterUpdate which references code and not a macro. The Mainform has a calculated control called "Balance".
The "Customer Payments" afterUpldate event references the code which is supposed to pass the value from Balance to a variable also called balance.
This is the code I use to describe the Calculated control on the Mainform:
Balance = Nz([Invoices payments].[Form]![Balance], 0)
However this produces an error because the calculate object is not identified.
Can anyone guide me how to correctly describe the object?
I have a mainform "Invoices Payments" and its subform is "Customer Payments" which has a field also called "customer Payments" which has an event AfterUpdate which references code and not a macro. The Mainform has a calculated control called "Balance".
The "Customer Payments" afterUpldate event references the code which is supposed to pass the value from Balance to a variable also called balance.
This is the code I use to describe the Calculated control on the Mainform:
Balance = Nz([Invoices payments].[Form]![Balance], 0)
However this produces an error because the calculate object is not identified.
Can anyone guide me how to correctly describe the object?
