User Profile

Trent · Jul 25 '07, 02:07 AM

That's strange, it works for me except the first line of the code for the Previous Button should be:

Code:

If index > index1 Then

The only scenario I can think of that would continue to give you this problem is you are still using index1 in the code for the Next Button....

Trent · Jul 24 '07, 07:11 PM

You are changing the lowerlimit (index1) when you click the Next button.

Try this for the Next Button

Code:

If index < index2 Then
               index = index + 1
          Else
             MsgBox "This is the last record of the data"
           End If

And this for the Previous Button

Code:

If index >= index1 Then
                index = index - 1

...

Profile Sidebar