I created a test form with a command button - on click event trying to run the following code. Just storing a value to a variable and trying to update field in table called seq_no.
Not getting any results -
Private Sub TestUpdate_Click()
Dim m_seq As Integer
m_seq = 33
DoCmd.RunSQL "update tmplineno set seq_no = " & m_seq
End Sub