Using a check boxon a subform to control a tcomand button 1

[kpryan]

Hi all,

I need to be able to make a command button on a main form become invisible from a check box on a sub form.
I have tried different option without success.

I know how to make a command button invisible
ie:button.visible = true/false etc.
But to get this to work once the checkbox on the sub form
is checked.
Any help appreciated.
Kp

 

[TheAceMan1]

Howdy kpryan! . . .

In the [blue]AfterUpdate[/blue] event of the [blue]Checkbox[/blue], try this:

[blue]   Me.Parent![purple][B][I]ButtonName[/I][/B][/purple].Visible = Not Me![purple][B][I]CheckboxName[/I][/B][/purple][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886