Subforms

[Chris]

I know how to put a form inside a form (a subform), but I
want one of sections to be a certain size when I open the
form. How do I do this? There is the header, middle (the
one I want to manipulate thesize), and footer. The middle
section is a columnar section and I want to show the
entire column.

 

[John Vinson]

I know how to put a form inside a form (a subform), but I
want one of sections to be a certain size when I open the
form. How do I do this? There is the header, middle (the
one I want to manipulate thesize), and footer. The middle
section is a columnar section and I want to show the
entire column.

And what if you have 32,118 records...?

I'm not sure what you mean. Do you want the size of the Detail section
of the form that you're using in the subform, and the size of the
Subform control itself, to expand and contract based on the amount of
data in the table? If so, I'm not sure there's any easy way to do so!

 

[Chris]

The middle section has a set length of 16 rows. I just want
to show those sixteen rows in the subform.

 

[John Vinson]

The middle section has a set length of 16 rows. I just want
to show those sixteen rows in the subform.

All I've figured out how to do is to cut and try: open the Form you're
using as a subform in design view, adjust the size of the sections,
view some records and count rows; then expand or contract it to get
the right size. Save the form when you're done. You can then open the
mainform and doubleclick the lower right corner of the Subform
control; it should size the subform to fit the Form object within it.