Showing/ Hiding controls at runtime

[winshent]

I want to show/ hide a sub report..

I can do it easily by setting the visibility using a global variable.. eg

Private Sub Report_Open(Cancel As Integer)
Me.Controls("rptBlockWindowsDetail_Sub").Visible = gShowSubReport
end sub

I would like to control this based on the value of a checkbox.. i tried this but an error says the checkbox control has no value..

Private Sub Report_Open(Cancel As Integer)
Me.Controls("rptBlockWindowsDetail_Sub").Visible = Me.Controls("chkWindows").value
end sub

Anyone got any ideas ?

 

[georgedwilkinson]

Set a default value of "True" or "False" on the checkbox object.

 

[pbaldy]

You might try the format event of the section containing the controls instead of the open event.

 

[winshent]

Worked !!

You might try the format event of the section containing the controls instead of the open event.

thanks very much...

 

[pbaldy]

No problem; glad it worked for you.