I have a form named "FrmSales" which includes a subform named "InvoiceDetailsSubform"
In the subfom, I have the following cotrols: Productname, Unit, Qty, UnitPrice, OUP and Amount.
On the form sales I wish to have a control that displays the total of the control "Amount" as the user enters the sales data.
What i did is: I created a control on the form footer of the form "FrmSales" and in the control, I attached the code
=Sum([Forms.FrmSales.InvoiceDetailsSubform.Form.Amount])
But when i return to Form view, I get an error display in the control.
Please what is not correct with what i have done?