Form Display

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutomatingForm Display 2
On Error Problem 3
Update Open Form 3
Problem DoCmd.GoToRecord with tabbed pages 1
use error handling to assign value 4
Send Email 2
error 2499 9
parameter in combobox 2

Top