updating a value on a table from a field 1

[wshs]

CurrentProject.Connection.Execute _
"Update tbl_fsource " & "SET Contp =" & Me.txtContAmt & " Where BFSIX='" & Me.LstBud.Column(7) & "'"

this code currently replaces the field on the table..
but i need to add that amount to make new balance.

i've tried doing

CurrentProject.Connection.Execute _
"Update tbl_fsource " & "SET Contp =" & contp + Me.txtContAmt & " Where BFSIX='" & Me.LstBud.Column(7) & "'"

but it didnt do anything different. Is it possible to add that "txtContAmt" to Contp instead of replacing it?

 

[snyperx3]

how about this?

CurrentProject.Connection.Execute _
"Update tbl_fsource " & "SET Contp = Contp + " & Me.txtContAmt & " Where BFSIX='" & Me.LstBud.Column(7) & "'"

-Pete

 

[wshs]

that works! thank you pete!!