[RESOLVED] Multi Step OLE DB Generated errors

[anguswalker]

It looks like you are deleting all records with a specific employee ID- presumably an employee who leaves. (BTW why not instead have a boolean field to mark that they have left. That way you retain the data)
Assuming cnn is an ADODB connection, try:

cnn.Execute("Delete * from EmployeeStates Where FK_EmpID =" & Me.Parent!EmployeeID)