empty subreport turn off label (Access97)

Topic

New Reply

I’ve tried several ways to accomplish the following (none of which have worked, mind you…):

If my subreport has no records… turn off the darn label…

Details are as follows: main report name is rptfinal, subreport label is Label41, subreport is called tblLegDistrictAdd subreport.

The label I need to turn off exists on the main report, it is not contained within the actual subreport…

Any ideas??? Thanks much… Jenn.

P.S. today is a two-thorn day… Thorn number 2 option groups… can’t seem to make ’em work… EVER! and i need to use one as a filter… if you know where i can get some good info on how to use them… please point me in the direction.

Reply | Quote

Replies

You can use the HasData property of a subreport, something like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me!MySubReport.Visible = Me!MySubRapport.Report.HasData
End Sub

As for option groups, the basic idea is that you check the value of the option group, not that of individual radio buttons within the option group. Microsoft still has a Query Samples database for Access 97 available for download here. It contains examples of using an option group to sort or filter a query.

Reply | Quote

Thanks Hans & Wendell

I went with putting the label on the report header of the subreport… but I’m certain there is a way to make it work from the subreports nodata event… it’s my coding that isn’t right…

as for the option group… i’ll start a new thread… thanks again everyone

Reply | Quote

One solution is to use the No Data property on the subreport to make the label on the main report hidden. Another is to put the label in the subreport report header so it will not be visible if there is no data.

As to option groups, they basically work with a set of radio buttons, and the option group takes the value of the selected radio button. What kind of problem are you having with using the value in a filter?

Reply | Quote