Ravi

If the control source is table.fieldname, scatter and gather have nothing to do with this and changes are being made directly to the table/cursor/view. To be able to undo the changes, the original contents have to be stored before changes are made. That is what buffering is all about. If the original developer used scatter/gather to store the original contents, your discard / cancel button would have to use gather memvar to restore the original contents.

You would be much better off ripping out this scatter / gather methodology and use buffering instead.


>>Make sure all of the Controlsources for the form have the m. in them. Otherwise the control is updating the field in the table and not the memvar.
>
>
>Hi Jim: this might be it. The controlsource is identified as Tablename.Fieldname. I don't see a m. anywhere. What do you recommend in this situation? See my response to Jim Nelso also. Thanks.