Synatax Error

[DS]

Can't find the Error!!
CurrentDb.Execute "UPDATE
[;DATABASE=C:\ProServ\Utility\DataSafe.mdb;].tblEmps, " & _
"SET tblEmps.EmpFirstName = " & Chr(34) &
Forms!frmBSEmployees!TxtFirstName & Chr(34) & "," & _
"tblEmps.EmpLastName = " & Chr(34) &
Forms!frmBSEmployees!TxtLastName & Chr(34) & ", " & _
"tblEmps.EmpActive = Forms!frmBSEmployees!ChkActive " & _
"WHERE tblEmps.EmpID = Forms!frmBSEmployees!TxtEmployeeID;"

Any help appreciated
Thanks
DS

 

[Ken Snell \(MVP\)]

Get rid of the comma after tblEmps in your second line.

(You don't say what the error is, but I'm guessing....)