[RESOLVED] update databse sql every records

[ksuwanto8ksd]

objconnection.Execute "update table1 set Field1 = field1-1 where field2 = " & val(me.text1)

this code should be "update FROM table1 "
but it is not doing anything to the records, anyway thanks for response