Error In Query (Update)

[Smart System]

What is wrong in this code ?

rs.Open " update TblName set FldNum=" & text1.Text & " where ID_FldName=" & Text2.Text , db, adOpenDynamic, adLockOptimistic

Knowing that
FldNum ---> Data type (Number)
ID_FldName ---> Data Type (AutoNumber)

And What the correct code ?

[QVeen72]

Hi,

Execute on Connection Object :

Db.Execute " update TblName set FldNum=" & text1.Text & " where ID_FldName=" & Text2.Text


Regards
Veena