Displaying datasheet over multiple Pages/ Forms/ Tabs

[JFo]

Basically I am creating a form on the fly that displays a number of records and populates a table. This all works fine and displays the relevant records in datasheet view. I would like to spread the display over a number of pages/ forms/ tabs is this possible? At the moment they are all shown in datasheet at once and you have to scroll down with mouse or tab to view all the records.

For example I would like to show the first 5 records on the first page/ form/ tab and then 10 records on 2nd and 3rd pages and then 6 on 4th and 8 on 5th and finally 2 on the last page

Is this possible or easy?

Thanks

[June7]

Certainly not easily. Forms are not multi-page. Might be able to do something with subforms or listboxes on a tab control.

5, 10, 10, 6, 8, 2 - an odd sequence. There will always be 41 records? Doubt this would be easy even on a report.

[JFo]

Thanks June7 it is actually for the check-list you have been helping me with, the order is just a possible sequence but will always be different

For example I would like 5 questions on first page, 10 on 2nd, etc

If it is in a report than how can the user enter the answers?

Cheers

[June7]

Didn't realize this was a question/answer form. Report would display the questions and the answers as entered through form. If you wanted same arrangement on report, same difficulty applies.

If the sequence is inconsistent then doubt can be done. Programming depends on consistency. What criteria would determine the sequence?

[JFo]

What criteria would determine the sequence? the equipment type will determine how many questions per page

[June7]

Frankly, sounds like more trouble than its worth.

[JFo]

thought this may be the case as I have not had any responses to this question after asking many times

Thanks