[AccessD] How can I match the subreport to back color changes inthe 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 



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Cindy Fraase
> Sent: 22 November 2005 15:50
> To: Access Developers discussion and problem solving
> Subject: [AccessD] How can I match the subreport to back 
> color changes inthe main report?
> 
> 
> 
> Hi all,
> I've learned a lot just reading all your posts, but I've 
> finally found something I can't figure out from the archives. 
> I have a main report that changes the back color in the 
> detail section alternately. This works fine, but there is a 
> subreport in the detail section. I can't figure out how to 
> have the subreport change color so that it matches the main 
> form. I'm sure this is easy for all you geniuses out there! TIA Cindy
>  
>  
> Cynthia Fraase
> Asst. Controller
> Direct: 678-325-3251
> Cell:     770-318-0628
> Fax:     770-641-2656
>  
> www.officeimagesinc.com
>  
>  
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>