Selecting data from MSHFlexGrid vb6
Posted on 2007-10-12
This issue is driving me nuts as it should be simple:
I want to select a cell of retrieved data and have it displayed in a textbox.
I have a form with a MSHFlexGrid that uses Adodc to pull data from a SQL table (select title form titles).
The results of the query show up in the MSHFlexGrid as they should and the data will display in the textbox. However, no matter which cell I choose only the 1st (top) row will display in the textbox. I am using the following:
Private Sub MSHFlexGrid1_Click()
txtTitles.Text = Adodc1.Recordset.Fields("title")
Thanks in advance for your help.