• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

Why the value DataGrid.Row is limitted within 10

The DataSource property of this DataGrid is an ADODC. After User change the data, I want the DataGrid focus on the Changed row. The Codes are:

    Dim lngBookID As Long
    'grd2Books is a DataGrid
    lngRePlace = grd2Books.Row 'Get the Current Row
   
    'Modify the Data
     ...............
    'adoBooks is ADODC, the DataSource of DataGrid
     adoBooks.Recordset.Move lngRePlace, adBookmarkFirst
       
But when I select the row after 10th, the value of lngReplace remains 9 for ever.  why??
0
Iaskyou
Asked:
Iaskyou
1 Solution
 
appariCommented:
grd2Books.Row  returns the current row no from visible rows.

for your purpose use grd2Books.Bookmark insted of grd2Books.Row




   Dim lngBookID As Long
   'grd2Books is a DataGrid
   'lngRePlace = grd2Books.Row 'Get the Current Row
   lngRePlace = grd2Books.Bookmark
   'Modify the Data
    ...............
   'adoBooks is ADODC, the DataSource of DataGrid
    adoBooks.Recordset.Move lngRePlace, adBookmarkFirst


hope this helps
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now