checkboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lauren B - 29 Apr 2005 15:09 GMT

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

Reply to this Message

Dennis - 29 Apr 2005 15:36 GMT

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.

> Is there a way to link a checkbox on my main form to a text box on a subform
> within the main form.
[quoted text clipped - 5 lines]
>
> LB

Reply to this Message

Jason Rice - 29 Apr 2005 15:37 GMT

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

Signature

Jason Rice

> Is there a way to link a checkbox on my main form to a text box on a
> subform within the main form.
[quoted text clipped - 5 lines]
>
> LB

Reply to this Message