Update Query error = Data type mismatch in criteria expression

[AAAndy]

What is wrong with the below. I have been trying to figure this out for like 2 hours now.

Update Query error = Run-time error '3464': Data type mismatch in criteria expression

    sSQL = "UPDATE dbo_tbl_Custom_Subscription_Subscriptions"
    sSQL = sSQL & " SET [varExtensionSettingValueList] = '" & LStringEmail & "' WHERE [intSubscriptionID] = '" & Me.txtintSubID.Value & "';"
    Debug.Print sSQL
   
    CurrentDb.Execute sSQL, dbFailOnError

[ranman256]

it means youre trying to put a string in the number field.
remove the quotes from the ID.
sSQL = sSQL & " SET [varExtensionSettingValueList] = '" & LStringEmail & "' WHERE [intSubscriptionID] = " & Me.txtintSubID.Value

[JoeM]

Is the intSubscription field text or numeric?
If it is numeric, you do not need the quotes around it, i.e.

WHERE [intSubscriptionID] = " & Me.txtintSubID.Value & ";"

[AAAndy]

That is fixed now. thanks.