>I am working on a form with buffering set to optimistic row buffering set on. When I do an append blank on the table and then do a tablerevert the record is still there with the default values I have selected still showing. Anything I have KEYED on the form after the append blank BUT before the tablerevert is gone. Any help or suggestions would be greatfully appreciated. And yes, I'm a novice :)

Do you have anything in the insert trigger code that does a tabelupdate() for you or otherwise moves the record pointer which would also do a tableupdate?