"UPDATE" SQL Statement

[Guest]

.....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.

 

[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.

 

[Guest]

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