>Hi all:
>
>One of my forms uses Scatter and Gather commands to populate fields. I would like to place a commandbutton called "Discard Changes" the clcick event of which should discard any changes a user has made to the currently viewed record.
>
>How should I approach this? TIA.
To summarize all previous posts:
1. Ensure that your form controls are linked to the memory variables, e.g. ControlSource="m.FieldName" (not Table.FieldName or Table.m.FieldName)
2. Think about change in the design - one data object as form's property for the control sources looks much better - you can have multiple instances of your form with this approach (if you need them).
3. When you need to revert the data - just load it from table (Scatter) and Refresh.
4. If you wish to clear the form for a new record - just empty the variables/object that is ControlSource (Scatter Blank) and Refresh.
Questions? ;)
Kind Regards
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!