Hi,

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

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.



>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