"UPDATE" SQL Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Speaking of spelling mistakes, is that 'tlbCLIENTS' in the where clause
supposed to be 'tblCLIENTS'?
 
Back
Top