>>I looked in SCATTER, GATHER, OLDVAL(), GETFLDSTATE(), plus some others and still don't know how to do this. I have a form with already INSERT INTO auth (id) VALUES (person.id). Now, the form has all the fields from the AUTH table but the person table remains selected (SELECT person). Then there is a Combobox.InteractiveChange that need to clear all the fields (along with disabling/enabling the textboxes), how to I clear the fields which have not been updated (only that the AUTH table has the appended record waiting for TableRevert() or TableUpdate()).
>>
>>Chuck
>
>Not quite sure, if this is an answer, but look at the BLANK command at Help.

Thanks Nadya. This one helped me out too. I'm working in FPW 2.6 and had been doing a SCATTER TO aTemp MEMO BLANK and then a GATHER FROM aTemp MEMO. I checked the help file and the BLANK command is valid there as well.

............Rich