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

 

[bhicks11 via AccessMonster.com]

What even did you put this in?

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

 

[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")

 

[bhicks11 via AccessMonster.com]

I put it in the main report properties - data tab - filter. Also, in case
there is not data, in the no data property of the report, you can use this:

MsgBox "There is no data for this report. Cancelling report...", , "No Data
for Report"
Cancel = True

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

What even did you put this in?

[quoted text clipped - 18 lines]
I've tried this in both the Format and Print Events of the Detail section.

 

[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")