Same Report Dynamic Control Source

  • Thread starter Thread starter tr_international
  • Start date Start date
T

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.
 
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.
 
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.
 
"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.
 
Back
Top