 <p>THANK YOU SO MUCH FOR INSPIRING ME mark_matters, though it's not just <code>UPDATE fab SET no_sj='SJ000001' WHERE no_fab='FA000005'</code> but i modified it because i actually using vs.net to update the data so i made this simple sub to be called on the button that worked as update button:</p> <pre><code>Sub update_no_sj_on_fab() Dim xupdate As String Dim x As Integer Dim xmycmd As OdbcCommand xubah = "UPDATE fab SET fab.no_sj=? WHERE no_fab='" &amp; txtno_fab.Text &amp; "'" xmycmd = New OdbcCommand(xupdate, Mycn) xmycmd.Parameters.AddWithValue("no_sj", txtno_sj.Text) xmycmd.Prepare() x = xmycmd.ExecuteNonQuery xmycmd.Dispose() Return End Sub </code></pre>