Reports/Subform Record Source

[Don Stone]

Greetings--
In A2007, I am trying to implement someone else's report design. The report
has three subforms where the main report and all three subforms are based
upon a single query. I believe that each subform could display more than
one record.
Does this sound like a reasonable design? It seems to me that subforms
would normally have data sources different that the main form, right?
The bottom line is that in viewing the report, it "requests" the ID (that
ties the tables together in the query) 3 times which is the number of
subforms. The report then displays OK but is missing the data from all
subforms.
Can someone give me some help? I feel as if I'm going around in circles.
Thanks for the help!
Don

 

[KARL DEWEY]

Check the Master/Child links of the Form/Subform to see if they are set to
the ID.

 

[Don Stone]

Thanks for the help. However, the links are OK. Any other ideas?
Is it OK to use subforms on the report or should I change them to
subreports?

 

[GeoffG]

The report has three subforms

It seems to me that subforms would normally
have data sources different that the main form.

The report then displays OK

Does this sound like a reasonable design?

Is it OK to use subforms on the report or should I change them
to subreports?

Don,

In the above extracts from your posts, you use "report" and "main
form".

I think your last question hits the nail on the head. You need
sub-reports on your main report, not sub-forms. As you no doubt
know, you can link sub-reports to the main report (using
Master/Child links), just like you can link sub-forms to main
forms. Access creates the links automatically if the table
relationships are in place and you drag the sub-reports to the
main report in design view.

Geoff

 

[Don Stone]

Geoff--
Thanks for the additional help! I will check out your suggestion.
Don