Same Report Dynamic Control Source

[tr_international]

I've created reports (letters) in A03 copied from Word docs. Report is
based on query with criteria from a form's check box selection and will
open to the correct account, works like a charm.
My issue is the "address block" (text box) for this report could have
up to 10 different addresses for each account. The address table is
linked by a unique account ID. How can I print the report for every
"address block" that is not empty?

My first solution was to create 10 reports for each available
address.Here is a pseudo-code concept.

Report Name: Letter #1 A1
AddressBlock(textbox) = Address1 (as the control source)

Report Name: Letter#1 A2
AddressBlock(textbox) = Address2 (as the control source)..and so on,
and so on.....ect.

10 reports per letter and I still have 8 letters left to copy! How
silly.

By the way I am pretty familiar with DoCmd and OnOpen events. And many
concepts discussed here. Not exactly a newbie but pretty beat up and
burnt out by something that seems so simple.

Any help is appreciated.

 

[Duane Hookom]

If you have 10 different fields for addresses then consider creating a union
query so you end up with possibly 10 records (or less). This would normalize
your data and allow you to use one report.

 

[tr_international]

Duane,
Thanks so much for the quick response. You are an absolute asset to
this newsgroup.
I'll give it a try and let you know.

Thanks again.

 

[Duane Hookom]

"You are an absolute asset to this newsgroup."
I have also been call similar without the "et" ;-)

If you have issues or don't understand the suggestion, feel free to come
back and ask.