Events of the grid are not triggered if you interact with the recordset directly.
>Hi,
>
>Thank for your advise, I had already gone through the knowledge base articles before hand and already using the SP5. I finally mangaged to get it right.
>
>BTW, how come when I programmtically delete the record, the afterdelete event
>never trigger ? as I need to keep track of the bookmark
>
>>Do you have the latest SP installed?
>>
>>See these:
>>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195840
>>http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195472
>>
>>BTW, clicking on the second row should return you 1 since the rows are 0 based!
>>
>>
>>>Hi,
>>>
>>>My VB6 application form is using MS datagrid where it is populated with data,
>>>so whenever my user select/click any of the row, I want to bookmark it so that
>>>I can do some manipulation to it, but I can't get it to work.
>>>
>>>On clicking the row, my bookmark is still remaining at the old value
>>>until I click it again to get the current select row. Below is my code example
>>>that will display the value 2 when I select the second row, but on selecting
>>>back the first row, it will not trigger.
>>>
>>>Private Sub DataGrid_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
>>>
>>> msgbox "The row = " & datagrid.Row
>>>
>>>End Sub
>>>
>>>I also had tried to keep track of the current row by using the code below too, but
>>>it didn't work for me, it keep giving me the old value until I reclick it gain.
>>>
>>>Private Sub DataGrid_SelChange(Cancel As Integer)
>>>
>>> msgbox "The row = " & datagrid.Row
>>>
>>>End Sub
>>>
>>>Please kindly advise me how to solve this problem of letting my user
>>>to click the row, where I will bookmark it for retrieve later.
>>>
>>>Thank you