retrieve record number from clicking on data grid

[smcmanus]

I have a data grid and when I click on a row, I want to know which record number it is in the recordset object.

 

[jitter]

You could use the following to get what you want. I am putting the value in a text box for example purposes but you could do whatever with the value:

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
Text1.Text = DataGrid1.Row + 1
End Sub

The row property is zero based so I am adding one to it to give the actual record number. Hope this is what you were looking for.

 

[smcmanus]

Jitter...

This works fine, but when you scroll down the DataGrid, the rows number will always reset to the number your on in the DataGrid, therefore never getting a true position in the recordset.

Thanks

 

[neilkonitzer]

You may want to look at the Bookmark property and see if that sheds any light. Neil Konitzer, President
Freisoft

http://www.freisoft.com