checkbox to switch between discount and no discount on form
I am very very new to access and have bludgeoned my way through making an invoiceing system for our workshop but cannot work out how to do this last bit which I assume would be in vb in the way of an IF statement.
On the form there are 5 text boxes:
Total (Ex-Tax): =OrdersSF.Form!txtTotal
GST: =[txtTotal]*0.1
Order Total: =[txtSalesTax]+[txtTotal]
Discount 10%:
Invoice Total: =[txtOrderTotal]-[txtDisco
On the form beside the Discount 10% entry is a checkbox and I would like it to display a 10% discount from the order total when checked and retotal the amount to the Invoice total, and when unchecked put a 0 discount in the discount and display the order total in the invoice total without the discount removed.
As I said I am not really sure as to what needs to be done be it a new query or code but any help would be great.
I hope I have explained what I need well enough to get some help on this.
Thanx
The Pro
On the form there are 5 text boxes:
Total (Ex-Tax): =OrdersSF.Form!txtTotal
GST: =[txtTotal]*0.1
Order Total: =[txtSalesTax]+[txtTotal]
Discount 10%:
Invoice Total: =[txtOrderTotal]-[txtDisco
On the form beside the Discount 10% entry is a checkbox and I would like it to display a 10% discount from the order total when checked and retotal the amount to the Invoice total, and when unchecked put a 0 discount in the discount and display the order total in the invoice total without the discount removed.
As I said I am not really sure as to what needs to be done be it a new query or code but any help would be great.
I hope I have explained what I need well enough to get some help on this.
Thanx
The Pro
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the Grade and points :-)
ASKER
The Pro