My qudate query is not running showing error : key violation. Although when i tries to run the query directly is doesnot show any error and it is updating the records. But when i am trying to run it from the form, due to LOCK violation table not updated.
my SQL is
UPDATE MEMBERS SET MEMBERS.EL = [EL]-[FORMS]![LEAVE_UPDATE]![TXTNOD]
WHERE (((MEMBERS.ACCOUNT_NO)=[FORMS]![LEAVE_UPDATE]![TXTAC]) AND (([FORMS]![LEAVE_UPDATE]![LEAVE_TYPE])="EL"));
my SQL is
UPDATE MEMBERS SET MEMBERS.EL = [EL]-[FORMS]![LEAVE_UPDATE]![TXTNOD]
WHERE (((MEMBERS.ACCOUNT_NO)=[FORMS]![LEAVE_UPDATE]![TXTAC]) AND (([FORMS]![LEAVE_UPDATE]![LEAVE_TYPE])="EL"));
Last edited: