Hi Sandi;

>Is there any way in the debug window to suspend when a field (in a table)'s
content changes?

Yes.. In the beggining of your program you must call debug and them, Just go to the breakpoint dialog and set the type of breakpoint to "Break when expression has change " and at expression field just put
the present expression of your field




CLAUDIO

>
>I have a form that is changing the description of a lookup table and I need to find the code that is causing it. There is a relationship in my form such that the grid's field is a candidate key. (APINVOIC.ACCOUNT is the primary key of ACCT.ACCOUNT)
>
> Column1 Column2
>Header Account Description
>Controlsource APINVOIC.account Myaccount.description
>
>
>
>
>Ok this is right. I enter 1200 in column 1 and column 2 displays the correct description. Then I backtab and replace the 1200 in column 1 with 1100 (which should change the record pointer in the MyAccount table to a different record.) The description changes in column 2 to the description which belongs to 1100 - this is correct. At this point I think the record pointer moved correctly and I am pointing to the 1100 record. The problem is that when I look at the data in the MyAccount table, I see that :
> 1200 Description2
> 1100 Description2
>
>So the original description that went with 1200 (Description1) has been replaced with Description2 and now both of my records have the same description and Description1 is lost so somehow, instead of just moving the record pointer to a different record in the MyAccount table, the control has somehow replaced the contents of the description with the second description. The description changes outside of the transaction - at this point even if I choose Undo the change is permanent.