Is the field you are updating in the same table? You cannot do that via a trigger then. Think about it: the trigger fires, and then changes a value in the same table, which fires the trigger, which changes a value in the same table, which fires the trigger, ... in other words, and infinite loop...