Pass row(s) of Flexgrid to textboxes - How?

[VBKid04]

I have a Flexgrid which is filled by a Recordset (the contents of which are gained through a SQL query).

The recordset may contain around eg. 10 records, but what I want, is that when a user clicks on one row, the contents of each cell in that row, are displayed in appropriate textboxes.

Example:
When the Flexgrid is populated, it will have (as an example) 5 cells per row...

These cells are named:
CustID, CustSurname, CustForename, CustPhone, CustAddress

When the user clicks on the the 3rd row of the Flexgrid (which is actually the 3rd record in the recordset), I would like each field to be displayed in its appropriate textbox:

txtCustID, txtCustSurname, txtCustForename, txtCustPhone, txtCustAddress


I have thought of 2 ways to do this:
1. Pass each cell value directly to each textbox
2. Pass the row to a recordset, then get populate the textboxes by using the recordset values...


A small problem with both ideas:
What if the user should click more than 1 row, eg. they click 3 rows?
How would I then do this?

Is it possible I could then send the 3 rows (3 records) to a new recordset, and then send each record in turn to the textboxes (and use back/forward buttons to scroll)?


Can anyone please help?

[VBKid04]

Nobody know how ?

[MartinLiss]

If your textboxes were a control array it would be very simple.

Dim intIndex As Integer
    
    For intIndex = 0 To MSFlexGrid1.Cols - 1
        txtMyControlArray(intIndex) = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, intIndex)
    Next

Even if it's not you can still do it pretty easily.

Dim intIndex As Integer
    
    For intIndex = 0 To MSFlexGrid1.Cols - 1
        Select Case intIndex
             Case 0
                txtCustID = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, intIndex)
             Case 1
                txtCustSurname = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, intIndex)
            ' etc
        End Select

Next

[mendhak]

Do you need this multiple-row-click functionality? What I mean to ask is, if it's not a necessary feature, then you can remove it by setting the SelectionMode property of the grid to flexSelectionByRow.