subreports subform

[brad]

Can somebody tell me how to turn a subreports column of
data's visible propert to false. I have tried many
different ways and always get a bad form/report reference
error.

I need the correct reference to the column of data in the
report.

Also please tell me where to place the event procedure.
I have been trying the onload() and onformat()

I can't go into the subforms control to turn it off
because once I get this working I am going to be using a
conditional statement.

 

[Marshall Barton]

Can somebody tell me how to turn a subreports column of
data's visible propert to false. I have tried many
different ways and always get a bad form/report reference
error.

I need the correct reference to the column of data in the
report.

Also please tell me where to place the event procedure.
I have been trying the onload() and onformat()

I can't go into the subforms control to turn it off
because once I get this working I am going to be using a
conditional statement.

To set the visbility of a control for the entire
form/report, you can use the Open event.

controlname.Visible = False

To set it for a control in a subreport, it should be in the
subreports Open event.

If you want to set it from the main report, use the Format
event of the main report section containing the subreport
control:

subreportcontrolname.Report.controlname.Visible = False