Binding a checkbox to a subform

[Bhat59]

Hi, Is it possible to bind a checkbox in the main form to a filed in the subform? When I go to the property sheet of the checkbox & see its control source, only the fields in the main form are shown for binding but not the fields in the sub form.



Actually I have four check boxes one each for Video,Audio,Photos and Notes. Whenever numbers of their discs are typed in the subforms, check boxes relating to them in the main form should be marked as checked. If the fields are left blank then they should be marked as unchecked.

[Bhat59]

I think I solved the problem through the expression builder in the property sheet of the form. Only thing is that the check mark didn't appear in the related table.

[RuralGuy]

You can *only* bind control to fields in the RecordSource of the form on which the control resides if you want the control to affect the RecordSource. Obviously the control can *show* data from other sources but then it does not affect the tables.

[Bhat59]

OK, Thank you for the reply. I am surprised because when I was manually marking the check box, it was affecting the table! I will mark the thread as solved.