how to print a form with subforms expanded?

[Singlespeed]

I would like a have a simple print out for my form

In the header I have officer drop list and between date parameters that the 3 subforms all use on the form

one subform displays cases open
one cases closed and one live cases

since the volumes for each officer vary from 5 to 40 rows I have verticle scroll bars and only show 5 rows on each subform

when I print it out I want the report to show expaned subforms to display all the rows

of course the print out needs to be for the selected officer and between dates that are selected

Any ideas?

When I try to print from the 2007 globe it behaves as if there parent/child relationships are not working!

and When I use the button wizard it prints a blank report

 

[vbaInet]

Forms are for data manipulation - editting, inserting and deleting. Reports on the other hand are for displaying data.

You should be using a report.

 

[Singlespeed]

yeah - I was being lazy

I have now done a report for it!

 

[vbaInet]

yeah - I was being lazy

I have now done a report for it!

We all love shortcuts but sadly not all shortcuts are feasible.

Happy to hear you've got it sorted.