Making sub reports invesible

[Simon]

I have this repot that has 3 text boxes

Summer Brochure
Winter Brochure
Skiing Brochure


Which will have -1 or 0 depending if true or false


I also have 3 sub reports for each brochure


How can i set it to make the a subreport invesiable if one of the
brochures is false 0


Thanks

 

[Al Campagna]

Simon.
I think you mean you have 3 subforms... one for each of the Brochure
types.
Do you mean that if SummerBrochure is False, hide the SummerBrochure
subform... and the same for each of the Brochure types.
In the OnFormat event of the report section that contains the brochure
subforms...
SummerBrochureSubform.Visible = [Summer Brochure]
WinterBrochureSubform.Visible = [Winter Brochure]
SkiingBrochureSubform.Visible = [Skiing Brochure]

Didn't have time to test, but that should do it.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."