Open Subform From Yes/No

[Daerio]

I'm trying to open a form (within my current open form) based on whether or not a yes/no field is checked.

I'm sure this has already been answered somewhere else, and I apologize, but I'm a bit lost on these forums. I tried searching for this to no avail.

Thanks in advance.

 

[John Big Booty]

Welcome to the forum.

Instead of deciding to open it or not based on the status of your check box, why not simply set the sub-form's Visible property based on the Check box, in which case you could use the following in the Main Form's On Current event;

Me!YourSubformName.Visible = Me.YourCheckBoxName

In this case if the check box is checked the Sub Form will be Visible otherwise it will be hidden.

 

[MStef]

Look at "DemoSubFormA2002.mdb (attachment, zip).
Open "frmMAIN" and try. Adapt it as you need.

 

[Daerio]

Thanks for the help, I should be able to muddle through it now.