>Thank for your advise, therefore, is there any way to let it trigger
>the events if I code manipulating the recordset programmtically ?

When you delete a row, you can call your self the afterdelete event (just like any other proc). VB won't do it for you.


>In addition, why is some of row highlighted ? How can I control
>it so that only those bookmark row is highlighted as sometimes,
>the highlighted is gone or all row is hightlighted.

If you implemented codes from the articles belows, that's why you have row highligthed. Simply remove it.


>
>
>
>>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