Subform fields locked (1 Viewer)

[mjwillyone]

Friends,

I have a subform that I have attempted to lock all but one field (a checkbox.) Unfortunately, it appears that even though I have made sure (under field properties) that the field is unlocked, I cannot enter anything in directly in the subform. The field in the table is not locked. If I open the table, I can easily check and un-check the checkbox. I have opened the actual subform by itself and can check and uncheck the checkbox. However, when I go to form where the sub-form is placed and attempt to check/uncheck the checkbox, I am not able to do so. Any ideas???

I want to use the checkbox to run reports from a query that looks for those fields that are checked.

Thanks,
Mike

 

[aleb]

What does the status bar tell you when you try to update the yes/no field on a subform?