checkboxes

[Lauren B]

Is there a way to link a checkbox on my main form to a text box on a subform
within the main form.

I want Text1 (on Subform 1) to only be visible if Checkbox 1 (on Form 1) is
checked.

Thank you for any assistance.

LB

 

[Guest]

I assume your subform has several records in a a relationship to your main
form.
In the On Current event for the sub form put the following
if Forms![Form 1].CheckBox1 = True then
Text1.Visible = True
else
Text1.Visible = False
end if

You will also need to put similar code in the after update event of the
check box on your main form to make the Text1 visible or not on the currently
displayed record on the subform.

 

[Jason Rice]

Yes it can be done.

Use something like this in the main form's On Current event and Checkbox1's
After Update event:

SubForm.Text1.Visible=Me.Checkbox1.Value

HTH