SQL Update in VBA

Hello all

I have been working on an update querie in VBA to update my SQL 2005 server, but I can't seem to make it work, so I think I need a second set of eyes.

Please Login or Register  to view this content.

I keep getting the same error Incorrect syntax ner "=", debugging shows strSQL = Update tblAttendance_Count[][]Set userID= '31'[][]Set sDate='4/21/2010'

I have never used SET in VBA before so I am not sure I am using it properly.