Sub Form Visible

[aids2]

I am having problems with making a subform visible or not depending on the selection of a check box on another subform.

I have a master form calle frmEO and then a subform that has a check box, check27.
when the form opens if check 27 is selected then another subform is visible. The master form has the control over the subfom.
I have tried puting the following code in the on open action for the master form but it doesnt work.

If Forms!frmEO!frmsubInsp!Check27 = True Then
Forms!frmEO![Repeat Frequency].Visible = True

ElseIf Forms!frmEO!frmsubInsp!Check27 = False Then
Forms!frmEO![Repeat Frequency].Visible = False

End If

Any help would be appreciated.

 

[WB786]

Try this instead:

If Forms!frmEO!frmsubInsp!Check27 = True Then
Forms!frmEO![Repeat Frequency].Visible = True
Else
Forms!frmEO![Repeat Frequency].Visible = False
End If

WB