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