Issue on condition WHERE ...AND

[Onlylonely]

Hi Guess,

Appreciate if you could give some hint to me on this.

sSQL2 = "Update Issuetbl Set [Issuetbl].[Result] = 'Pass' WHERE ([Issuetbl].[Serial_Number] = '" & Forms!Checklist!txtSN & "') And ([Issuetbl].[Character_ID] = '1')"
CurrentDb.Execute (sSQL2)

 

[isladogs]

It would help if you said what the datatype of Serial_Number and Character_ID are

Assuming the first is text & the 2nd is number then:

sSQL2 = "UPDATE Issuetbl SET [Issuetbl].[Result] = 'Pass' WHERE [Issuetbl].[Serial_Number] = '" & Forms!Checklist!txtSN & "' AND [Issuetbl].[Character_ID] =1"
CurrentDb.Execute sSQL2

If both are numbers:

sSQL2 = "UPDATE Issuetbl SET [Issuetbl].[Result] = 'Pass' WHERE [Issuetbl].[Serial_Number] = " & Forms!Checklist!txtSN & " AND [Issuetbl].[Character_ID] =1"
CurrentDb.Execute sSQL2