Selecting a row in a MSFlexGrid

[starswirl]

I have a flex grid on a form. And I am trying to have it so that the user can click any where on the flex grid row and it will trigger a select statement using one of the fields on that row.

For example.
the row includes Last Name, First Name, and Date of Birth
I want the user to be able to click anywhere on that row and bring up the inforation by searching with a select statement using the Last Name field.

I know its confusing and I really don't know how else to explain it. But I know I need help.

 

[Arthur1]

This is a tricky problem. I have one idea? There is a mouse over method that could be used depending on where you were on the screen?