Subreport Groupings for Form Letter Report

[Louise99]

I have a report in Access that is a form letter (in details) that pulls a subreport when user sets a field to yes in a form. The form has the unit information and client code - its table is linked in a query the client table with names and addresses (to populate the details).

it works fine for single numbers - but if I have, for example, two "unit number"s it prints both on the same page for the client but twice (i.e. two form letters with two units when I just want one letter for the two units). I'm sure I don't have something correct in the relationships but I can't tell what.

I did try to search the forums but I didn't see anything helpful. Any links or advice appreciated.
Thanks!



Thanks!

 

[dhookom]

I'm sure I don't have something correct in the relationships but I can't tell what.

We can't tell either because you haven't provided your table structures and relationships. We also need to know the record sources of the main and subreports as well as the Link Master/Child properties of the subreport.

Duane
Hook'D on Access
MS Access MVP

 

[Louise99]

The table with the clients' names has the master field & the units has the child field. (One to Many) The source of the main report (the addresses) is clients table - master field - and the subreport is child.

Thanks!

 

[dhookom]

Are you suggesting the Record Source properties of
main report: [clients]
subreport: [child]

I'm having trouble understanding what you are seeing in your report and what you want to see. Maybe it's because you use "form" three times in your intial post. Isn't this a basic main and sub report?

Duane
Hook'D on Access
MS Access MVP