|
| 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
December 14th, 2009, 06:44 PM
posted to microsoft.public.access.reports
|
|||
|
|||
make subreport2 visible based on condition
Help, I am running Access 2003 and have
trouble getting this work right. I have an unbound subreport that contains 3 additional subreports. I want only one of the 3 to be visible based on the value in a combo box on a selection form. I can't seem to get the reference right and have tried several variations. If Forms!frmWeeklyGLrpt!cboCC = 1 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = True Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = False End If If Forms!frmWeeklyGLrpt!cboCC = 2 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = True Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = False End If If Forms!frmWeeklyGLrpt!cboCC = 3 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = True End If I keep getting Runtime error 2455 "You entered an expression that has an invalid reference to the property Form/Report." Can anyone help me out? 
|
|
#2
December 14th, 2009, 09:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
make subreport2 visible based on condition
Opal wrote:
Help, I am running Access 2003 and have trouble getting this work right. I have an unbound subreport that contains 3 additional subreports. I want only one of the 3 to be visible based on the value in a combo box on a selection form. I can't seem to get the reference right and have tried several variations. If Forms!frmWeeklyGLrpt!cboCC = 1 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = True Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = False End If If Forms!frmWeeklyGLrpt!cboCC = 2 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = True Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = False End If If Forms!frmWeeklyGLrpt!cboCC = 3 Then Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visib le = False Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visib le = True End If I keep getting Runtime error 2455 "You entered an expression that has an invalid reference to the property Form/Report." I think that happens if your code is in the main report's Open event. Try moving it to the report header's Print event or maybe you need it in the main report section that contains the subrptGLWeekly subreport. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
