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.
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.