[AccessD] How can I match the subreport to back color changesinthe main report?

Andy,
I just wanted to say a belated thank you. You're solution worked great!
Cindy
 
 
 
Cynthia Fraase
Asst. Controller
Direct: 678-325-3251
Cell:     770-318-0628
Fax:     770-641-2656
 
www.officeimagesinc.com
 
 
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Tuesday, November 22, 2005 11:08 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How can I match the subreport to back color
changesinthe main report?

Hi Cindy
Try this. Immediately after you put the code to set the BackColor
(presumably in the OnFormat of the Detail section) put:

Me.subRep.Report.Section("Detail").BackColor =
Me.Section("Detail").BackColor

Where subRep is the name of the subreport control on your main report.
If
your subreport has >1 section you'll need to repeat for each. Oh and
don't
forget to make the background style of the individual controls
transparent..

-- Andy Lacey
http://www.minstersystems.co.uk