I using two tables H1, D1 where FieldID is primary key for H1.

Now i am trying to insert table H details. on excution of line 5 i will end the program. now table H details should rollback.

Any Idea pls.

Private sub cmbSumit()
conn.BeginTrans
conn.BeginTrans
conn.Excute "update H1 set Fname = 'City1' where FieldID=7"
Conn.CommitTrans
Conn.Excute "update D1 set name = 'Ram' where FieldID=7"
Conn.CommitTrans

End Sub