>>If you do NOT have "m.", then the actual fields from the table will be updated any time a value is changed in such a control. In such a case the SCATTER will have no effect other than to replace the memvar values, though these will NOT be the same as the ControlSource values (which come directly from the table if they do not have "m." coded).
>>
>Hi Jim: Thank you for your input. Even Jim Booth had suggested. This is a form that I have inherited in an app. And the controlsources are identified like so:
>
>
TableName.FieldName
>
>Will it work if the controlsource reads as
>
>
TableName.m.FieldName
>
>Thanks.
No, it won't.
I guess that you do NOT have buffering enabled.
To accomplish what you want to do I would recommend:
1) enable TABLE buffering
2) leave the ControlSources as they are
3) issue a TableUpdate() on the tables involved in the "save" routine
4) issue a TableRevert() in your 'undo' button code.
This way there is NO SCATTER/GATHER involved at all.
good luck