calculations

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am using windows 98 and Access 2000. I have a button on
a form that, when i press it, it will take an amount, that
I have inputted, and calculate a tax amount and put that
amount in another text box, which is blank, and then add
the amount and the tax for a total in another text box. I
have used the code:
Private Sub Tax_Click()
Tax = (Val(Amount) * 0.06225)
Total = Tax + Amount
End Sub
when I press the button, it correctly calculates the
numbers, but it uses the same tax amount and total for all
the records. How can I use the code to calculate those
specific numbers for just the current record.
 
Back
Top