Tick box True/Fales, Display/Hide OLE Object...

[scottmfitzge]

Hi everyone - i wonder if someone could help. I am looking to understand the VBA code that should be used for a tick box on one of my forms. When the tick box is "True" i want an OLE object (which is on the form but hidden) to be "Displayed". When the tick box is false, i want the OLE Object to be "Hidden" - any ideas what code i should use here? Really appreciate your help guys.

 

[Rich]

Me.MyControl.Visible = Me.MyCheckboxName
In the FormCurrent Event
In the AfterUpdate Event of the checkbox
Call Form_Current