Update statement not working

[rizunb]

Hi People
I am running an update statement in access, but it not updating the table, its not giving me any error as well
here is the sql :

DoCmd.RunSQL ("update Employees set Firstname = '" & fname & "', Lastname = '" & lname & "', Title = '" & Title & "', workphone = '" & phone & "', Active = '" & Active & "', section = '" & Section & "' where employees.employeeid = " & empid & "&quot

This is a very simple sql statement. Its just simply doing nothing. Insert statements are working fine but updates are not. Does this have to do some thing with rst.update or rst.edit?
I am not using any of these.
Please guide me a little
Thanks in advance

 

[TLady]

There may be no new records to update