Help on Subform please.

[bill crumpton]

I have a form that contains a yes/no control that when checked will make the subform visible and when unchecked make the subform invisible. The problem I am having is that when I check the control the subform will not appear unless I close the form and enter into it again. I have tried requery the Master form but that doesn't seem to help. how can I get the subform to dynamically appear when the yes/no control is pressed? Thanks all for your help.

BAC

 

[Jack Cowley]

Does your code in the After Update event of the Check box look something like this:

If Me.CheckBoxName = -1 Then
Me.MySubform.Visible = True
Else
Me.MySubform.Visible = False
End If

This code works for me....

 

[bill crumpton]

Thanks Jack that worked perfectly.

BAC