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