MSHFlexGrid recordset selection

I created a ADO and linked MSHFlexGrid boject to that ADO. When I select any record in the grid, how to find which recordset in that ADO object is selcted?
If I use
ADO_object.Recordset.Fields(0).Value

I always get first recordset's value

Pl help.

You could try:

MSHFlexgrid.Recordset.Fields(0).Value

Don't know if that will work, but it's worth a try :)

If you aren't doing sorting on the MSHFlexgrid, the following might work:



ADO_Object.Recordset.AbsolutePosition = MSHFlexGrid.Row





That should set the location in the record set to the current row of the flex grid.

Hope this helps,

Nathan Liebke