If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting in unlinked subreport
Hi all,
In Access 2007, I am using a main report which has three sub reports. The main report shows some details per salesman, two of the subreports are linked to the main report and show some details for this salesman, too. The third subreport shows a ranking of all salesmen, so this one is not linked to the main report. So far, the reports show exactly what I want. Now I would like every salesman to locate himself easily in the ranking (i. e. the unlinked third report). Therefore I would like to do the following: In the report for the salesman A, his results in the ranking should have a colored background (e. g. yellow), in the report for the salesman B, B´s results should have the yellow background, etc.. My question is, how can I address the properties of a control in a sub report, triggered by the event "OnOpen" from the main report. So far, I have been trying this: Reports("MainReport").Section(acDetail).Controls(" SubReport").Controls ("FirstName").BackColor = RGB(255, 0, 0) |
Thread Tools | |
Display Modes | |
|
|