Multi-column form

[Guest]

Hi
I have a query (which I have also done as a 'make-table' - if that makes it
easier) that I want to display on a form. The fields are Assistant, Sales,
Qty etc and I would like to display them in this format:
Assistant 10 11 12 13
Sales 250 125 350 400
Qty 2 5 11 6
Can anyone help me, please. I have spend the last two days trying to get it
right!
Cheers.

 

[Duane Hookom]

I have done this before using multiple subforms across the form. It requires
opening a recordset to place primary key values into hidden text boxes on
the form. These text boxes are used as the link master property of the
subform controls.

 

[Guest]

Thanks Duane.
The strange thing is that I've set up a multi-column report that is fine -
and looks as I want - but when I embed it as a sub-report into another
report, it loses its formatting and becomes a single column down the
left-hand side. Do you know why this is? Would it be easier to do this as a
form, rather than a report?
Thanks for your help
Andy.

 

[Rick Brandt]

Thanks Duane.
The strange thing is that I've set up a multi-column report that is
fine - and looks as I want - but when I embed it as a sub-report into
another report, it loses its formatting and becomes a single column
down the left-hand side. Do you know why this is? Would it be easier
to do this as a form, rather than a report?
Thanks for your help
Andy.

Subreports have no concept of "pages". Pages are the responsibility of the
parent report. A multi-column report that is set up as "Down, Then Across"
will start a new column at the bottom of the *page* and a subreport has no
idea where that is so you get one long column.

Basically multi-column subreports only work when set up as "Across, Then
Down" or when the subreport control has CanGrow set to false. Then the
bottom of the control will take the place of the bottom of the page.

 

[Duane Hookom]

Great explanation Rick.