G
Guest
I am using a form to display the results of a query.Because the dataset is
large I have used the following code to step through the records one at a
time triggered by the on Timer property of the form.
Private Sub Form_Timer()
DoCmd.GoToRecord , "", acNext
If fldName = "LastRecord" Then
DoCmd.GoToRecord , "", acFirst
End If
End Sub
I would like to make each increment 20 records rather than 1 can anyone
suggest how?
large I have used the following code to step through the records one at a
time triggered by the on Timer property of the form.
Private Sub Form_Timer()
DoCmd.GoToRecord , "", acNext
If fldName = "LastRecord" Then
DoCmd.GoToRecord , "", acFirst
End If
End Sub
I would like to make each increment 20 records rather than 1 can anyone
suggest how?