subform problem

[don]

I am new here and a novice with access, so i appologise
if this has been discussed.

I created a form with the wizard that contains a sub-
form. The form works great, but I'm having problems
printing. I put a macro on the form that's a PrintOut
function with the print range set to selection. My
problem is that not all the records in the subform print.

How do I get the sub-form to print all of it's associated
records and to generate extra pages only if it needs to?

 

[Steve Schapel]

Don,

Whereas it is theoretically possible to print an Access form, this is
not the principal purpose of forms, and the functionality is limited.
Reports are the database objects which are intended for the presentation
of data. I would suggest that you make a query to provide the set of
data you want to print, and then use this query as the record source of
a report. I realise that there will be some work and a learning curve
in this, but I assure you it will be worth the effort.