>I have designed a form which displays data from a table. When I run the form I have a procedure which selects a particular record in the table and then using the scatter command I store all the fiekds for that record to memory variables and then display them by making the controls on the form equal that of my memory variables.
>
>When I modify lets say 'Description' field from which the value is m.Description.
>
>What is the best way to replace the records description. Do I need to store the new description to m.Description on save then use a gather command or is there something else that would be easier. any help would be greatly appreciated.
>
>Many Thanks
Why you do this? I think the easiest way it to set Buffering to the Table/Cursor to Row or Table Bufferin, Bind all controls to the fields of that table and than When The user Click on Save Button TABLEUPDATE() otherwise TABLEREVERT()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.