text box help

[Arwyn]

I have a text box called Sub Total, (currency). In the next text box I have to copy the sub total figure into the next text box called VAT which then calculates the tax in another text box called total.

Sub Total VAT Total

My problem is that I am making errors in copying figures from the sub total box to the vat box. Any ideas on how I can do something, message box? or similar to stop my errors.

Please remember that not all figures in sub total are entered into vat because enot all items have tax.

Thank you

 

[khawar]

Its simple


[vat]=[sub total]

 

[DanWall]

You need to add 2 new expression columns to the form

VAT: Cost * Tax Rate
Total: Cost + [VAT]

Then add a total to the Cost, VAT and Total field columns, and link them to your 3 corresponding text boxes.