How to hide a subform ....

A

Alain

Hi,

I would like to know on how to hide a subform that is nested on subform
that is nested on a main form based on a value of a checkbox.
I have tried many combination of the following line of code but bo success.
My sub-subform is still visible

If Surplus Then
Forms!frmOwnedProperties.frmPropCosts.Form.frmPropSales.Form.Visible =
True
End If

TIA
 
M

Marshall Barton

Alain said:
I would like to know on how to hide a subform that is nested on subform
that is nested on a main form based on a value of a checkbox.
I have tried many combination of the following line of code but bo success.
My sub-subform is still visible

If Surplus Then
Forms!frmOwnedProperties.frmPropCosts.Form.frmPropSales.Form.Visible =
True
End If
Click to expand...


It's the subform control that you want to make invisible,
not the form object it's displaying:

Forms!frmOwnedProperties.frmPropCosts.Form.frmPropSales.Visible=False

Depending on where that line of code is located, you might
be able to shorten that line significantly by using Me to
reference the form containg the line of code.
 
Top