Code:
rs.Open " update TblName set FldNum=" & text1.Text & " where ID_FldName=" & Text2.Text , db, adOpenDynamic, adLockOptimistic
FldNum ---> Data type (Number)
ID_FldName ---> Data Type (AutoNumber)
And What the correct code ?
Smart System
Last Activity: Jul 14 '10, 02:14 AM
Joined: Jul 14 '10
Location:
-
Error In Query (Update)
What is wrong in this code ?
Knowing that
FldNum ---> Data type (Number)
ID_FldName ---> Data Type (AutoNumber)
And What the correct code ?
No activity results to display