Calculations in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 fields in my table - Subtotal, Tax and Total. I have created a form
from the table for users to input the figures. Tax is 10%, so how can I make
Access automatically calculate the tax and the total once the subtotal has
been input.
 
either set the Total Text box Control source to "=val(txtSubTotal)*1.1"
or set the after update event on the Subtotal text box to:

If val(me.txtSubtotal) > 0 then
txtTotal = txtSubTotal + txtSubTotal * 0.1
end if
 
I tried putting the expression into the Total Text box control source. When I
put a figure in the Subtotal field on the form, the total is calculated and
shown. However, it is not saved into the Total field within the table. Any
ideas why this would be?
 
Back
Top