I have a form in Access named customer. This form displays customer details with the fields:
cust_id, name, address, phone
This form also has a related subform named order. The subform contains a list of transactions related to the current customer on the parent form. The fields are:
cust_id, ord_id, description, value
I want the parent form named customer to display the total value of all transactions in the subform. Ive tried to do this using a text box on the parent form with the following:
But it produces and error.
Can you please let me know what I am doing wrong?