Automating Tick Boxes

[Paul Cooke]

Hi all, firstly just to let you know i have tried the various soultions to my problem that have already been posted but to no avail, so i hope someone can help me with this one please.

I have a form that starts off with a "tick Box" what i would like to do is enable the other fields in the form once the tick box has been ticked.

The other option i was looking at was automaically ticking the tick box if some data was entered in one of the other fields.

Any help on this one will be gratefully recieved.

many thanks

 

[jeremie_ingram]

Useing VBA you could place code behind the checkbox after update event that would change the Enabled property to true if it is checked and false if its unchecked. Set the default values to enabled false and the default vaule of the check box to false.

So when the check the box, they can enter data, when they uncheck it everything disables.


Take a look at this example.

 

[Paul Cooke]

Thanks Jeremie, will give it a go a let you know