Go back to original record after Add is cancelled

[gundie]

I have a datagrid on a form that's bound to a table(ID, Company, Contact). I've created two buttons, one for Add function (using .AddNew), one for Cancel (using .CancelEdit).

When I click the Add button, it shows a new record for add, no problem so far. During the Add function, when I click on the Cancel button, the new record disappeared, and the pointer goes to the last record in the datagrid.

Question: Is there a way to get the pointer to go back to the record that it was originally pointing to, not necessary at the last record, before I tried to add a new record?

 

[mansii]

Of of many ways is to create a "holder".

Dim LastRecord as Integer

'in the AddButton_Click
'Set LastRecord = DataGrid SelectedRow

'When the Cancel button is clicked
'Set the DataGrid selected row to LastRecord

 

[gundie]

I tried with Selectedrows, but it is read-only property. How do I set the row to be selected?