"UPDATE" SQL Statement

F

Fred

.....I've been trying to make this UPDATE sql statement work:

sqlSTRING = "UPDATE tblCLIENTS SET tblCLIENTS.CL_ID = '" _
& Me.txtNEW & "' WHERE ((tlbCLIENTS.CL_ID) = '" _
& Me.txtORIGINAL & "');"


I always get a VB "...Run-time error '3219'...Invalid Operation..." error
message. What am I doing wrong.
 
V

Van T. Dinh

SQL construction looks OK but I normally use:

sqlSTRING = "UPDATE tblCLIENTS SET tblCLIENTS.CL_ID = '" & _
Me.txtNEW & "' WHERE ((tlbCLIENTS.CL_ID) = '" & _
Me.txtORIGINAL & "');"

Post the relevant VBA code (around the SQL construction) and mark which line
of code errors out. I don't think the problem is in the SQL construction
unless you have spelloing error in Table / Field names.
 
C

Chaim

Speaking of spelling mistakes, is that 'tlbCLIENTS' in the where clause
supposed to be 'tblCLIENTS'?
 
Top