Microsoft Acess Forms-Check Boxes

[Andy]

I have a very complicated database that involves SQL servers. I was thrown
to the wolves for maintaining and fixing it when necessary. there are
several checkboxes on one of the forms. When the form is open these check
boxes can be checked, but can not be changed after that. There is also
another control that updates the check boxes. When this control is changed
it will uncheck or check the box as necessary, but as soon as the user
rechecks the box, it can not be changed again. Does anyone know what is
happening? I want to fix it that a user can check or uncheck the box at any
time.

I've looked at the locked and the enable properties. I have another
checkbox that works fine so I compared the properties. The properties match
except for the BeforeUpdate Event. The working checkbox has [event
procedure] in this field. This procedure shows a message box if the checkbox
is clicked before selecting something in the control source so i don't think
it has anything to do with my problem. The only other difference is the
underlying table has a default value of 1 for the working checkbox and 0 for
the nonworking checkbox. I tried changing the default value for my non
working checkbox but no luck.

Thanks for any help you can provide.

 

[Jeff Boyce]

Andy

From your description, I'd have to guess that there is code somewhere that
is locking/unlocking those checkboxes. The code might be associated
directly with the form itself rather than with any specific checkbox.

Regards

Jeff Boyce
Microsoft Office/Access MVP