Recordset is not pulling specific records to update 2

[DYM03]

My Recordset is updating all records instead of the data I want it to pull. What am I doing wrong?

Set rstEmployees = db1.OpenRecordset
("SELECT * " & _
"FROM EmployeeTime " & _
"WHERE [EMPLOYEE_NAME] = '" & [EmpName] & "' AND [EMP_SSN] = '" & [SSN] & "';&quot

With rstEmployees
db1.Execute "UPDATE EmployeeTime SET [EMPLOYEE_NAME] = '" & [EmpName] & "', [PERFROM] = '" & [PerFrom] & " ', [PERTO] = '" & [PerTo] & " ', [REG] = '" & [Reg] & "', [OTP] = '" & [Otp] & "', [VAC] = '" & [Vac] & " ', [SCK] = '" & [Sck] & "', [HOL] = '" & [Hol] & "', [LWO] = '" & [Lwo] & "', [LWP] = '" & [Lwp] & "', [TOTAL] = '" & [Total] & "';"
db1.Close
End With

 

[SkipVought]

You need a WHERE clause with your update

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[DYM03]

Thanks!

 

[WayneRyan]

DYM,

With the db1.Execute, you don't need the recordset. You
do need the Where clause, but the recordset isn't used.

Wayne