Error called Expected end of statement in update query?

[sunny]

Hi All,
I am trying to update my record through form and for that I have written a code also.But in update command I am getting compile error.Some syntex problem.any one please correct it.

Dim rs As DAO.Recordset, db As DAO.Database
Dim res As Boolean
Dim query As String
Dim temp
Set db = CurrentDb
query = " Update User set Last_Name=" & txtUserId & ",First_Name= " & txtFirstName& ",Email_Id= " & txtEmailId & "',User_Type= "cmbUserType & " from User where User_Id=" & txtUserId & ""
Debug.Print query
db.Execute query
''If txtUserId = "" Then


''MsgBox "Please select Record first"
'If Err.Number = 0 Then
'MsgBox "Record Updated successfully." & db.RecordsAffected
'Else
'MsgBox "Record not Updated The error is: " & Err.DESCRIPTION
'End If
End Sub

Thanks

[dsmacs]

In line User_ID = " & txtUserId & ""

Add a semicolon between the inverted comma's;-

User_ID = " & txtUserId & ";"

I think you should place the test to see if a user has been selected first before executing the query? Include exit sub and end if

[sunny]

Thanks for the reply..I changed what you have said.but its giving the error called "RUN TIME ERROR 3075" (SYNTEX ERROR MISSING OPERATOR IN QUERY EXPRESSION 'ADMIN FROM USER'.IN db.Execute query LINE.
I am a beginner in vab access so dont know much about coding and syntex.please try to come up with a correct solution.I am using access 2003.
THanks....

[dsmacs]

Hi Sunny,

Are you using the users surname as their ID number? What happens if you have two Smiths? set Last_Name=" & txtUserId ?

Without seeing the table or form, I can suggest anything further. Place a copy with some sample data and someone will advise or email me at

d [dot] mcdonald [at] ozemail [dot] com [dot] au

Cheers
Darren