Subform check box not allowing to be checked

[Richo]

Hi

I have a check box on a subform that has a control souce back to a table.
The field on the table is a Yes/No data type.
When run the form and ckick on the check box nothing happens. I have put
code in the "OnClick" event (like a Msgbox) and the message box is not
displayed.
It seems like the form does not know when I select the check box.

Hope some can help me as it is stopping me working, must be a property I
think...

 

[Stuart McCall]

Hi

I have a check box on a subform that has a control souce back to a table.
The field on the table is a Yes/No data type.
When run the form and ckick on the check box nothing happens. I have put
code in the "OnClick" event (like a Msgbox) and the message box is not
displayed.
It seems like the form does not know when I select the check box.

Hope some can help me as it is stopping me working, must be a property I
think...

Check the Locked and Enabled properties of the checkbox. They should both be
'No'.

 

[Allen Browne]

There's a stack of things that could be going on here. Some suggestions:

1. Ensure the AllowEdits is Yes in both the main form and also in the
subform.

2. Ensure the check box's Enabled property is Yes, and Locked is No.

3. If the subform is based on a query, open the query directly and see if
you can edit the data there. If you can't see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

4. Test with the cursor already in the subform. (There may be some reason
why it can't get out of the main form and into the subform, so the event is
never firing.)

5. Temporarily cut all the code from the form's module, and remove any
macros in the event handlers for the form and its controls. If this solves
the problem, some code or macro is cancelling the update.

 

[Richo]

Thanks Allen not sure what it was, tried the first few options and none of
them work, then I deleted the sub_form and created it again and all works
great now.
--
Regards

Richo

There's a stack of things that could be going on here. Some suggestions:

1. Ensure the AllowEdits is Yes in both the main form and also in the
subform.

2. Ensure the check box's Enabled property is Yes, and Locked is No.

3. If the subform is based on a query, open the query directly and see if
you can edit the data there. If you can't see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

4. Test with the cursor already in the subform. (There may be some reason
why it can't get out of the main form and into the subform, so the event is
never firing.)

5. Temporarily cut all the code from the form's module, and remove any
macros in the event handlers for the form and its controls. If this solves
the problem, some code or macro is cancelling the update.