Good Afternoon,
I have a bill template which I have created. I have a form where the user will insert the bill information, including Name, address details
There is a seperate form where the user then inserts the costs text which is entered into column A, the Amount in column B, if it is a disbursement the text goes into A and the Amount into column C. In column D is the VAT. If when entering the information they tick VAT it calculates the VAT.
At the end of the table gives the Sub totals which is in the Footer of the template.
The issue I am having is if the amount is manually edited the subtotals update without any problems, but the VAT column does not, unless you press F9. I am wanting to force the update should an amount be added or edited?? Can anyone advise if this is possible???.
Many thanks,
I have a bill template which I have created. I have a form where the user will insert the bill information, including Name, address details
There is a seperate form where the user then inserts the costs text which is entered into column A, the Amount in column B, if it is a disbursement the text goes into A and the Amount into column C. In column D is the VAT. If when entering the information they tick VAT it calculates the VAT.
At the end of the table gives the Sub totals which is in the Footer of the template.
The issue I am having is if the amount is manually edited the subtotals update without any problems, but the VAT column does not, unless you press F9. I am wanting to force the update should an amount be added or edited?? Can anyone advise if this is possible???.
Many thanks,
