Printing subform data in Access XP

  • Thread starter Thread starter Raj K
  • Start date Start date
R

Raj K

Hi,
When I print a form which has a few subforms, all the
records print out the data from the 1st subform, instead
of getting their respective data for each record.

In the form I have an On Current record which changes the
data when a user moves from one record to the next. How is
this achieved when printing.

thanks,
Raj
 
How is this achieved when printing.
Click to expand...

By using a Report (rather than a Form, which is designed for onscreen
viewing) for printing. Base the Report on a query which references a
form control as a criterion on a unique field.
 
The data I'm displaying in the subforms is related 1 to
many to the data in the form. If I use a report, I get
multiple lines of the same data. THat is why I'm trying to
use a form instead. Can this be done with a report, i.e
display about 20 fields of data from the main table along
with data from some other tables which are related 1-M all
on one page of a report?
 
The data I'm displaying in the subforms is related 1 to
many to the data in the form. If I use a report, I get
multiple lines of the same data. THat is why I'm trying to
use a form instead. Can this be done with a report, i.e
display about 20 fields of data from the main table along
with data from some other tables which are related 1-M all
on one page of a report?
Click to expand...

Sure, in two different ways: use a Report with a Subreport (exactly
analogous to a form with a subform); or, probably more efficiently and
easier, use the Report's Sorting and Grouping feature. Group by the
main table record, and put its fields on the section header; put the
many-side records in the detail section.
 
Back
Top