Grand total in Textbox

I have field named amount in access tabel i want to grand
total from amount field in text box it will update too
when I enter amount in amount field
plz reply me soon
Thank You

Grand total of the "Amount" field:

data1.recordset.movefirst
Do until EOF
total = total + data1.recordset.fields("Amount")
data1.recordset.movenext
Loop

To update your textbox every time, put it in the text1_change event. I think that's what the event's called. Haven't used VB for a while.

Hope that's what you want :)

SQL solution:

select sum(amount) from table