subform pages

[mfpoore]

Hola gurus,
I have form that has a subform that itemizes charges. I would like to have multiple columns?, so that when all the space allotted is used, the next page appears next to it.
attached is a .doc with a picture of my form. I would like to use the extra space shown to continue the list of animals (at the top of thew subform you can see it says 36 animals, but I only have about 8 shown).
This form will be printed (I realize reports are for printed, but I have reasons for using a form)so a scroll bar doesn't help, and I do not want it to get out of the space I hace given it.
thanks,
mfpoore

 

[stardusty]

M, If I'm following, using the extra space is going to exhibit 8 more of your present total of 36 animals. That prints out half (16) of your animals. What will you do with the other half?

Brent

 

[mfpoore]

Stardusty,
If I figure out how to do it, I can get about twenty on by playing with size etc.
I usually only have a few with greater than twenty, so I can print out a separate sheet for them...but would rather only do that a couple of times, instead of a hundred
thanks for looking at my problem,
mfpoore

 

[stardusty]

In your originating table create a numeric field that you will eventually make a primary field. Number from 1-36 in that field for respective first through thirty-sixth animal.

Create a query based on your originating table, where the criteria for your newly devised numeric field is ">8".
Brent