making reports visable or invisable

[Simon]

I have a report with a text box (BrochurePrices) which dispaays -1 or
0 depending if true or faule


I also have a sub report that has the prices. What i would like to do
if BrochurePrices is True then i would like subreport to be visable if
false then subreport to be invisable

Any help would be great


Thanks

 

[Al Campagna]

Simon,
Use the OnFormat event of the report section that contains the subreport
to make a decision as to display the sub or not.
If BrochurePrices = True Then
Reports!rptYourMain!rptYourSubform.Form.Visible = True
Else
Reports!rptYourMain!rptYourSubform.Form.Visible = False
End if
or...
Reports!rptYourMain!rptYourSubform.Form.Visible = BrochurePrices
--
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."