I am using VB6 with Micosoft ADO Control 6.0 to access the SQL Server 6.5.
I have created a command button known as Cancel . What this cancel button should perform would be
(1) Cancel any update from user editing its current record and to resume the
(2) If the user try to add a record ( go to a blank new record) . By pressing this Cancel button should also return back to the record where he should be before the action of adding the new record.
(1) It should look like this for Cancel any editing changes
Name : abcd (Before editing)
Name : abcdefghijk (after inserting)
Name: abcd (after pressing the Cancel button)
How can all this be done?