How to automatically update text boxes (NEED IMMEDIATE HELP!!)

[PLEASE HELP ME. NOW !!!]

I have three text boxes. When a user manually inputs data in one text box, I
want the other two boxes updated automatically.

In other words, everytime Textbox 1 is updated, Textbox 2 and Textbox 3
automatically are updated.



For example,


TextBox 1 Textbox 2 (automatically fills in 100 x .5)
..5 is a rate
User enters 100 50


Textbox 3 (automatically fills in Textbox 1 + Textbox 2)
150

All 3 values are stored in a Table.

tblResults

txtVal1 txtVal2 txtValTotals
100 50 150

 

[tiger0268 via AccessMonster.com]

You can try firing on the after update event like so:

Air Code:

Private Sub Textbox1_AfterUpdate()
Dim txtbox1 as Integer
txtbox1 = Me.Textbox 1.Value
me.Textbox2 = txtbox1*.5
me.Textbox3 = me.textbox2 + me.textbox1

End Sub