Printing subform data in Access XP

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

On Sun, 30 May 2004 02:30:27 -0700, "Raj K"
wrote:

How is this achieved when printing.

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

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?


-----Original Message-----
On Sun, 30 May 2004 02:30:27 -0700, "Raj K"
wrote:

How is this achieved when printing.

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.

On Sun, 30 May 2004 15:38:11 -0700, "Raj K"
wrote:

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?

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public