>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.
Ravi,
I'd suggest buffering as David.
However if you'd go with scatter_gather then you could also support n-levels of undo too :)
-Create a custom form property 'oRec'
-Before starting edit :
scatter name thisform.oRec
thisform.refresh
Save :
gather name thisform.oRec
Discard :
scatter name thisform.oRec
You could use 'thisform.oRec' as if it were alias of your table. ie:
thisform.mytxtbox.controlsource = 'thisform.oRec.First_name'
Cetin