hey could anyone please tell me how can i retrieve the current recordset from a flexgrid control..what i mean is :when a user selects an entire row in the grid control this row has data contained in a specific recordset?HOW CAN I access those data fields and the entire recordset by using an "grdDataGrid." like command please help me...         

Hi,
Add a hidden column and put the primary key into it, then when the user clicks a row, use this hidden column to find the row in the RS. ie
public function FindRSWhereCol0IsPK(gd as msFlexGrid, rsSource as recordset)as recordset
  dim rsClone as recordset
  set rsClone = rsSource.Clone
  rsClone.Find "[pkfield]='" & gd.textmatrix(gd.row, 0) & "'"
  if rsclone.eof then goto exith
  set FindRSWhereCol0IsPK = rsclone
exith:
end function
Hope this helps
Kieron
PS. FlexGrid is not data-bound, as far as I am aware, hence the runaround.


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

...you can also use a loop comparing the "Bookmark" of your current record in the recordset and the cuurent row that the user had clicked, then use "Do..While". Put this on your flexgrid's click event:

--------------------------------------------
If flxGrid.Row > mRec.Bookmark Then
    Do While flxGrid.Row <> mRec.Bookmark
        mRec.MoveNext
    Loop
Else
    Do While flxGrid.Row <> mRec.Bookmark
        mRec.MovePrevious
    Loop
End If

--------------------------------------------
...then get the current field's data


____________________________
Funny thought:

Practice makes perfect.....
But nobody's perfect......
so why practice?