Sub Report Question

[Swarfmaker]

I have a main report with 2 subreports , "subrptInternalTraining" and
"subrptExternalTraining"
This works just as expected. However, sometimes there is a blank sub report
as no training has been undertaken. In such a case I would like a label to
appear saying "No Training".
I've tried the following with no luck.

If IsNull(subrptInternalTraining) then
Me!Label8.visible = True
Else
Me!Label8.visible = False
EndIf

Any Ideas?

Iain

 

[Swarfmaker]

What even did you put this in?

Bonnie
http://www.dataplus-svc.com

I've tried this in both the Format and Print Events of the Detail section.

 

[Duane Hookom]

Use a text box with a control source like:
=IIf(subrptInternalTraining.Report.HasData,Null,"No records in Internal
Training")

 

[Swarfmaker]

Thanks Duane, works a treat!!

Iain

Use a text box with a control source like:
=IIf(subrptInternalTraining.Report.HasData,Null,"No records in Internal
Training")