How to cancel changes in a record ?

[ndevriendt]

Hello,

I have a recordset that contain 4 fields.
Ex. CompanyID, address, postal_code, community
CompanyID = primary key
I change the address, postal_code and community at
one record.
When I click at an Undo button, he replace only the
last field where my cursor is located in the
original value.
The code after the Undo button = recordsetx.cancelupdate

Is there an easy way to replace all the fields that are
changed with the originaly value.
I think that my program make a save every time I move to an other field. I want actualy a save when I went to an other record. Is this possible ?

Thanks for your time and answer

Devriendt Nico
Developper

 

[jayesh2002]

Do u want to say when u go for undoing (CANCELUPDATE) the changes u did to that particular record it just replaces the last field of that record to the original value and other changes r left as it is ?

jayesh

 

[ndevriendt]

Jayesh,

thank for your quite respons.

Yes I want to say that cancelupdate only replace the last field of the that record that I change, and the other fields are automatically saved ?

Is this normal with cancelupdate command or are there other ways to cancel all changes that are made on a record ?

Thanks for your time and answer

Devriendt Nico
Developper