Data Macro in Access 2010

[rkalapura]

Hai
I am having a problem with a data macro attached in one of my table. It was working fine until a month ago, but now it stops. I really appreciate if someone look into this and advise the probable cause why it is not updating the table.

If Isnull([JobNo]) or Isnull([CellNo]) Then



Raise Error
Error No 1001
Error Description " Job Number or Cell Number Missing"

Else

Lookup a Record in KITSMASTER
Where Condition = KITID = TOOLMOVEMENT.KITID
Edit Record

SetField KITMASTER.AVMI
Value = No

setField KITMASTER.AVLOC
VALUE = [TOOLMOVEMENT].[CELLNO]

IF [TOOLMOVEMENT].[REQKIT]=YES THEN

Lookup a Record in PLATETOOL
Where Condition = KITID = PLATETOOL.KITID
Edit Record

SetField PLATETOOL.AVMI
Value = No

SetField PLATETOOL.AVLOC
VALUE = [TOOLMOVEMENT].[CELLNO]
ENDIF


It updates the first table KITMASTER without any problem and not updating the second table PLATETOOL. But if I remove the IF condition from it, it updates. This IF statement is asscociated with a Yes/No field [REQKIT], which if I select in the form, then only it should update the [PLATETOOL] table.

As I told before, it was working before with the IF statement, but I couldn't find out why it is not working now. I have already wasted 4 days now and I know it is difficult to suggest from this short lines, but any possiblilities in "Data Macro" is really appreciated. I have rechecked the value of [REQKIT] in the table and it picks the value "Yes" if we select it in the form, but fails to update second table [PLATETOOL] through the Data Maco.

Thank you and regards

[Stingaway]

Did relationships change in the database by any chance? I would try running an update query against the tables to see if you can update through the query - I have seen this happen before where a relationship had been added to the tables from the database level..