Need Help with Adding Values in Individual Text Boxes

[SoulBrutha23]

I need help. I am a beginner in VBA. There is a Access database that I am developing. In a form, I have some text boxes that will have numeric values in them. I need a procedure that will add up each number as inputed and will automatically give me a total in another text box. The total text box will automatically refresh with the correct number. ex. ---- stands for text box

label155 ----
label156 ----
label157 ----

Total ----

I need help please.....thanks!!!!!

 

[Databaseguy]

In the on exit event of each text box box, type:
call CalculateTotal()

Then cut & paste & modify this code as needed:

Private Sub CalculateTotal()
txtTotal = txt1 + txt2 + txt3 ......
End Sub

txtTotal is the textbox (or label) that you want the total displayed in. txt1, txt2 etc are the text boxes that have the values.... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy