Hello,
I have a form called “Projects” which contains a subform called “Invoices”. In the subform I have a field called “Amount”.
On the main form I have a field called “Total Cost”. When adding, editing or deleting records in the subform I need the Total Cost to auto sum the “Amount” column in the subform.
Could you tell me step by step how to do this?
Your help is greatly appreciated :)