using datagrid control to pick a record

[fwonny]

I have a form which searches for a customers' last name in a table. The result of the search goes to a datagrid control. How do I retrieve the value of the bound column (i.e. customerid)? The bookmark property only returns the absolute position of the record.

 

[ca8msm]

You just need to find the value using the index of the column. e.g. In the click event of the datagrid try

MsgBox DataGrid1.Columns(0)

this will give you the text that is in the 1st column. changing the 0 to the index you require will give the other details.