I am writing a software to display out 10 data at one time onto LCD TV before the next 10 data is replacing the earlier 10 records.
To do this, I am using a recordset to move at the back and recordset is moved next through 10 times of looping. Recordset is then bookmarked and linked back to screen before it is displayed out. You may need to see the attachment for further understanding.
However, if total records are 33, I do not understand why the last 3 data cannot be displayed out and through immediate windows tool, an error happen to the method Find. The output should display the last 3 data, however, the display has shown the first 10 data.
In summary,
0) 1st 10 data (display correctly)
1) 1st 10 data ---> 2nd 10 data (display correctly)
2) 2nd 10 data --> 3rd 10 data (display correctly)
3) 3rd 10 data --> 4th 3 data (Error has happened at here [if refer to attachment, not too sure what has gone wrong to the Find (Part 2) method]
Is anyone can help ?
To do this, I am using a recordset to move at the back and recordset is moved next through 10 times of looping. Recordset is then bookmarked and linked back to screen before it is displayed out. You may need to see the attachment for further understanding.
However, if total records are 33, I do not understand why the last 3 data cannot be displayed out and through immediate windows tool, an error happen to the method Find. The output should display the last 3 data, however, the display has shown the first 10 data.
In summary,
0) 1st 10 data (display correctly)
1) 1st 10 data ---> 2nd 10 data (display correctly)
2) 2nd 10 data --> 3rd 10 data (display correctly)
3) 3rd 10 data --> 4th 3 data (Error has happened at here [if refer to attachment, not too sure what has gone wrong to the Find (Part 2) method]
Is anyone can help ?