Data Type MisMatch

[Eranka]

CurrentDb.Execute "Update tblUser SET tblUser.UserPassword = '" & Replace(Me.Text4.Value, "'", "''") & "' WHERE [ID] = '" & Me.UserLogin & "'"

Hi Everyone

i am trying to run the above code when i run the code i get the data type mismatch error,



i want to update the password filed in the table with the value entered in the Text4 (contains letters,numbers,symbols)

Hope you could help me out to overcome this error.

[ranman256]

that means you are using a string in a number field, so dont use quotes around numbers:

WHERE [ID] = " & Me.UserLogin

[Minty]

If your ID field is a number you need to remove the string delimiters from it - try;

WHERE [ID] = " & Me.UserLogin

If not build the string before and examine it ;

Dim sSql as String 

sSql = "Update tblUser SET tblUser.UserPassword = '" & Replace(Me.Text4.Value, "'", "''") & "' WHERE [ID] = " & Me.UserLogin 

Debug.Print sSql   ' This will make the result of you string appear in the immediate window. You can cut  and paste that into the query editor to highlight the error

CurrentDB.Execute sSql