Form Hide / Unhide

[Xavier]

Is there an easy way to by default have a form either
hidden or grayed out unless a checkbox is checked for that
particular record.

Having a main form I would like to have the sub form
hidden or grayed out on all records unless a particular
checkbox is checked, then I would like it only to be
visible on those records where the checkbox had been
checked.

Is this a hard to do item?

Xavier

 

[Rick B]

In the onCurrent property for the form, build code similar to the following:




If [SomeCheckBox] Then
Me!TabCtl80.Pages(1).Visible= True
Else
Me!TabCtl80.Pages(1).Visible= False
End If




Rick B


Is there an easy way to by default have a form either
hidden or grayed out unless a checkbox is checked for that
particular record.

Having a main form I would like to have the sub form
hidden or grayed out on all records unless a particular
checkbox is checked, then I would like it only to be
visible on those records where the checkbox had been
checked.

Is this a hard to do item?

Xavier

 

[Rick B]

sorry. That code was to hide and display tabs. You should be able to do
the same with a subreport.


In the onCurrent property for the form, build code similar to the following:




If [SomeCheckBox] Then
Me!TabCtl80.Pages(1).Visible= True
Else
Me!TabCtl80.Pages(1).Visible= False
End If




Rick B


Is there an easy way to by default have a form either
hidden or grayed out unless a checkbox is checked for that
particular record.

Having a main form I would like to have the sub form
hidden or grayed out on all records unless a particular
checkbox is checked, then I would like it only to be
visible on those records where the checkbox had been
checked.

Is this a hard to do item?

Xavier

 

[Xavier]

Can Anyone share how to hide/unhide a subform or gray
everything out so it cant be used unless I place a check
in a Y/N box.

thanks
Xavier