Loop in batches, x number of records at a time

[russ0670]

I have a form which uses a loop command to output reports as a PDF

The reports take a bit of time to produce and the record set could contain 100-150 records.

Does anyone know a way that you can split the recordset down into batches.

Maybe have a button which creates 1-20 and another 21-40 and so on.

 

[vbaInet]

This is related to this thread right?
http://www.access-programmers.co.uk/forums/showthread.php?t=278875

Why don't you first review your process and make that faster? For batch, move next until you hit the batch number then exit the function.