I am using the datagrid to show some information about a person, but I have a password field that can not be shown in the datagrid for security reasons. I need to enable it so that when the user clicks on the row of the person whose password they need to verify, it will pop up in a seperate textbox. I am pretty sure that this would need to be done in the buttonclick event. This would be the query that I need to use to find the correct password:

"SELECT * FROM AuthorizationInformation " & _
"WHERE lastname = ****COL1CURRENTROW " & _
"AND firstname = ****COL0CURRENTROW " & _
"AND companyname = ****COL2CURRENTROW' ;", cnn,adOpenKeyset, adLockOptimistic


I don't know how to select the cells in the current row, to do a query on it. Anybody know how to do this?