Disappearing Combos

[PNGBill]

I agree, 12 reports mean there should be another way.

I will check how we have handled similar issues and inthe meantime, others may advise a better way.

You have 6 Reports now ?

 

[Robbyp2001]

Hi Bill, I have 8 reports. Four for Mid Term and the Four for End Term.

There are several report options:

Records by Form Class
Records by Teacher and Yeargroup
Records by Teacher, Subject and Yeargroup
Records by Selecting Individual Student

Each report has to be duplicated for Mid and End term reports.

If, as you suggested, a report is created for each Yeargroup then that will mean Yeargroups 7, 8, 9, 10, 11, 12 would have a report for Mid Term and the same again for End Term.

Rob

 

[PNGBill]

Report for < 10 and another for > 9. If this means 12 then yes, too many IMO

 

[PNGBill]

You could try this method.

In your code where you call for the report, create a TempVar eg "MTRReportGrade" - TempVars are new to 2007.

When the Reort opens, you have code in the Load event (try this first) to check for the value of TempVar MTRReportGrade and set the colours and font of the controls so only one is visible.

Report properties are different to Form properties and it is a while since I played with them.

I suggest you create a new thread specific to this issue and work through the problem with assistance and advice as required.

 

[Robbyp2001]

Many thanks once again Bill.

I will certainly try this as soon as I get some time to spend with it.

Rob

 

[Glue]

Something like this should work. You may also want to put the code on the on load event of the form...

Private Sub YearGroup_Exit(Cancel As Integer)
If Me.YearGroup > 10 Then
[Target Level].Visible = False
Else
[Target Level].Visible = True
End If

If Me.JobID < 10 Then
[Target Grade].Visible = False
Else
[Target Grade].Visible = True
End If
End Sub

 

[Robbyp2001]

Thanks for taking the time to reply Glue.

I assume that this code is for the report not the form. Can I ask on which event this code is inserted? Also, in line 7, you mention JobID should this be YearGroup?

The source for the Yeargroup on the report is [Year Group ID]. The fact that there are spaces in the name has been helpfully pointed out by Bill, but how would this impact on your code?

Thanks again Glue, much appreciated.

Rob