update error

[enrico via AccessMonster.com]

i have this update code behind my button:

sSql = (" UPDATE tblInterviewer " & _
" SET Lastname = '" & Me.txtELastname & "', " & _
" Firstname = '" & Me.txtEFirstname & "', " & _
" MI = '" & Me.txtEMI & "', " & _
" Position = '" & Me.txtEPosition & "', " & _
" Department = '" & Me.txtEDepartment & "' " & _
" WHERE InterviewerID = '" & Me.txtEClientID & "' ")

Set db = CurrentDb
db.Execute sSql, dbFailOnError
End If

the problem is every time i click the button an error occurs, stating a data
type mismatch in criteria expression. what is the problem basically when this
error occurs?

 

[Stuart McCall]

i have this update code behind my button:

sSql = (" UPDATE tblInterviewer " & _
" SET Lastname = '" & Me.txtELastname & "', " & _
" Firstname = '" & Me.txtEFirstname & "', " & _
" MI = '" & Me.txtEMI & "', " & _
" Position = '" & Me.txtEPosition & "', " & _
" Department = '" & Me.txtEDepartment & "' " & _
" WHERE InterviewerID = '" & Me.txtEClientID & "' ")

Set db = CurrentDb
db.Execute sSql, dbFailOnError
End If

the problem is every time i click the button an error occurs, stating a
data
type mismatch in criteria expression. what is the problem basically when
this
error occurs?

At a guess I'd say that InterviewerID and Me.txtEClientID are numeric values
so you don't need the surrounding quotes. Change the WHERE clause to read:

"WHERE InterviewerID = Me.txtEClientID"