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

 

[Pat Hartman]

Forms do NOT support columns. Forms are for interactive viewing. Reports are for printing. Subforms when printed will not expand to show rows not visible in their viewable area. Subreports WILL expand as far as they need to to show all detail items. The subreport can be multi-column even though the main report is single column.