Sub form on a report

[Hank]

I have a form with a sub form that works great.

What I want to do is duplicate the form as a report. The only change would
be to Sort the last names rather than the controlID (auto number).

So far I get the sub form on the report - but the information is not alway
correct.

I very green on child / master links... Could this be the problem and how
do I solve it?

Thanks
Hank

 

[Ken Snell \(MVP\)]

I am assuming that you put a subreport on the report, right? But you're
using a form as the Source Object of the subreport control? Not good to do
that -- build a separate report object that contains the subform's
information/layout. Then use that subreport as the SourceObject of the
subreport.

In that subreport's Sorting & Grouping menu (View | Sorting & Grouping), set
the sort order that you want to display in the subreport. Reports override
query's ORDER BY clauses, so it's usually necessary to set the sort order in
the report itself.

 

[Hank]

Ken,
That what i did.
I have build a seperate report containing th subform's information and it
works great except...
I get a seperate seperate pages of the report based on how many names are in
the subreport. If I have 6 names listed in the subreport, I get 6 pages of
the full report -- all identical. If I have 3 names in the subreport - I
get 3 idencial pages of the report.

Where did I go wrong?

Thanks again
Hank

 

[Ken Snell \(MVP\)]

Hard to say until you tell us what the main report's RecordSource query's
SQL statement is, what the subreport's RecordSource query is, what the
LinkChildFields and LinkMasterFields properties are for the subreport
control, etc.