msflexgrid search

[codesearcher]

Suppose you have this msflexgrid with records of firstname, lastname and dateofbirth and you have 5000 records of that.

I would like to do the search on the msflexgrid as the firstname as criteria. How do you do that?

I appreciate if there is a sample for this for me to study. TIA

[kamalkumar2023]

Hello codesearcher,

Dim jrow As Integer
For jrow = 1 To MSFlexGrid1.Rows - 1
If MSFlexGrid1.TextMatrix(jrow, 1) = Text1.Text Then 'column 1 means your firstname column
Text2.Text = MSFlexGrid1.TextMatrix(jrow, 2)             ' or you want any
End If
Next jrow