By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Access 97 Subform v. Subreport

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.