Hi all,
I have this update query that I'm struggling with, I do not have the right syntax but I'm not sure which the YES/NO field should use.
This gives me a 'Run-Time Error '13': Type Mismatch" error. The code worked properly prior to adding the AND to the WHERE clause. I've also tried using "0" and "-1" in place of True/False with no luck. I would like the update query to run only if the CoreRest field = False.
Any assistance would be appreciated.
I have this update query that I'm struggling with, I do not have the right syntax but I'm not sure which the YES/NO field should use.
Code:
Dim RecordUpdateSQL As String
RecordUpdateSQL = "UPDATE [tbl_SNModifiers]" & _
"SET LastCoreNumber= '" & Me.LastCoreLink & "'" & _
"WHERE [Assembly_Number]='" & Me.DeviceLink & "'" AND Me.CoreReset= False
DoCmd.RunSQL RecordUpdateSQL
This gives me a 'Run-Time Error '13': Type Mismatch" error. The code worked properly prior to adding the AND to the WHERE clause. I've also tried using "0" and "-1" in place of True/False with no luck. I would like the update query to run only if the CoreRest field = False.
Any assistance would be appreciated.