Access 97 Subform v. Subreport

[nathanwalsh]

What are some of the differences between subforms and subreports?
Here's my problem: I've got a form that lists a group of technicians.
The main form lists basic information (name, job title, etc) while a
subform lists specific ideas each technician has developed. The form
and subform are linked via the technician's name. This works fine-each
technician is listed, and the subform lists the ideas associated with
each person.

I've also got a report and subreport based off of the same information.
They are based on the same set of tables, with the same data included.
My problem is that no information will show up in the subreport, even
though it's listed in the subform.

The form and report are based on the same query. The subform and
subreport are based on the same table. The query's underlying table
and the subform/subreport table are linked. The underlying table's
primary key is the technician name that is linked in a one-to-many
relationship with the subform/subreport table.

Any ideas?

[MacDermott]

Have you checked the LinkMasterFields and LinkChildFields properties of the
subreport control vs the subform control?

<na*********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

What are some of the differences between subforms and subreports?
Here's my problem: I've got a form that lists a group of technicians.
The main form lists basic information (name, job title, etc) while a
subform lists specific ideas each technician has developed. The form
and subform are linked via the technician's name. This works fine-each
technician is listed, and the subform lists the ideas associated with
each person.

I've also got a report and subreport based off of the same information.
They are based on the same set of tables, with the same data included.
My problem is that no information will show up in the subreport, even
though it's listed in the subform.

The form and report are based on the same query. The subform and
subreport are based on the same table. The query's underlying table
and the subform/subreport table are linked. The underlying table's
primary key is the technician name that is linked in a one-to-many
relationship with the subform/subreport table.

Any ideas?

[nathanwalsh]

Yes - they're both exactly the same. In both cases the link is the
'Name' field of the query & table.