Yet another Question

[Douglas]

First let me say thanks to everyone for all their help, without you I would be lost (and prob bald from pulling my hair out in fustration).

I have a form where in I have several checkboxes. I have it set so that when someone checks the box another control becomes enabled for data input. However I have 2 questions.

1. If you check the box and then uncheck it the control remains enabled..is there anything I can do to make it disable again?

2. When you have finished inputing on "records" worth of data and click to start a new one the controls remain enabled..is there a way that they can be redisabled?

3. If the value for a checkbox that is "checked" is -1, what is the correct value for an unchecked checkbox?

Thanks!
Doug

 

[Peter D]

1. In the AfterUpdate event of the check box, you need to examine the checkbox value and set the enabled property of your control accordingly. This should also occur in your form OnCurrent event procedure.

2. Use the code described above in your form OnCurrent event procedure.

3. 0. It's better to use True (-1) and False (0).

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com