-
Hi,
I am trying to assign a record found in a recordset to a MShFlexGrid so that it can display the entire row when a name is seached. I am finding difficulties to assign the property of the MSHFlexGrid that will highlight the row. Here is the code I am using. Any help would be much appreciated. Thanks
Albert
If rsData.EOF Then
MsgBox "Couldn't find the Name"
Else
MSHFlexGrid1. = rsData.Fields.("Lastname").Value
End If
-
Hi Albert
Code:
Dim i As Integer
With MSFlexGrid1
.Col = 0
.Row = 2 'assuming we found match in row 2
For i = 0 To .Cols - 1
.ColSel = i
Next i
End With