Reports/Subform Record Source

D

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
 
K

KARL DEWEY

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

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?
 
G

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
 
D

Don Stone

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top