Show or Hide Subreport

[cantona]

Hi,

Ive got a report that contains a subreport in the details section of the report. I would like to display this subreport in all cases unless the field offer_code has a value of '33'. If offer_code has a value of '33' i would like to display a field called comments instead. Whats the best way to do this? Ive tried putting some code in the onFormat section of the main report along these lines...

If Me.Offer_Code = 33 then Me.Comments.Visible = True and Me.Sub_Rpt.Visible = False

This doesnt however work! can anyone help?

 

[Remou]

If I understand you, you need to add the code to the Current Event for the main form and the After Update event for Offer_Code.

 

[dhookom]

Try:

   Me.Comments.Visible = (Me.Offer_Code = 33)
   Me.Sub_Rpt.Visible = (Me.Offer_Code <> 33)

This assumes you have a control in your report section named Offer_Code.

Duane MS Access MVP
Now help me support United Cerebral Palsy