update SQL getting error

[vicsaccess]

sorry, i know this is going to be something simple but I've been looking at it for a while and don't see anything wrong. I'm working on an update SQL and am getting an error 3144 syntax error in update statement. anyone see anything wrong that i'm missing? the debug is coming back looking good with


UPDATE 2lognamet SET RequestName='aaa', SET LocID='1', SET Lev='2'WHERE DsID='a222'

        If (DCount("DsID", "2lognamet", "dsid='" & Me.txtdsid & "'") > 0) Then
            Dim sqlupdate As String
            sqlupdate = ("UPDATE 2lognamet " & _
                "SET RequestName='" & Me.txtname & "'" & _
                ", SET LocID='" & Me.cbolocation & "'" & _
                ", SET Lev='" & Me.cbolev & "'" & _
                "WHERE DsID='" & Me.txtdsid & "'")
            Debug.Print (sqlupdate)
            CurrentDb.Execute (sqlupdate)

[vicsaccess]

oh, that's funny. ever look at something so long you can't see what's in front of you. If at first you don't succeed use the query builder and look at the syntax. I didn't need all the "sets". whoops.

        If (DCount("DsID", "2lognamet", "dsid='" & Me.txtdsid & "'") > 0) Then
            Dim sqlupdate As String
            sqlupdate = ("UPDATE 2lognamet " & _
                "SET RequestName='" & Me.txtname & "'" & _
                ", LocID='" & Me.cbolocation & "'" & _
                ", Lev='" & Me.cbolev & "'" & _
                " WHERE DsID='" & Me.txtdsid & "'")
            Debug.Print (sqlupdate)
            CurrentDb.Execute (sqlupdate)