How can I view the data in textboxes related to the MSHFlexGrid row that I clicked on

[VBLearner6]

Dear Friends,

How can I view the data in textboxes related to the MSHFlexGrid row that I clicked on?

Using MS Access as backend and have 10 textboxes. Whatever the row I click on the MSHFlexGrid it should show tha related data in those textboxes.

Thanks.

[dee-u]

You can try it like this.

Private Sub MSHFlexGrid1_SelChange()
    text1.Text = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.row, 0)
    text2.Text = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.row, 1)
    text3.Text = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.row, 2)
    '...
End Sub