Open Subform with Button

[denileigh]

Hello all,

I know I have seen this before and I have searched the forums several times and cannot find it now.

Maybe I am searching the wrong thing. Can someone point me in the right direction?

I need a button on my form that opens a subform or subforms when clicked.

How do I set this up?

Thanks,
Di

 

[Carl Foster]

denileigh, the easiest solution is to make sure the toolbox wizard is on while putting the button onto your main form. it will pop up with a number of options, one of them being opening other forms.

Once this is done, you can go into the VB editor for that form and copy the code to open other forms if you want.

 

[denileigh]

Thanks! I know how to use the wizard. I'm sorry, I probably didn't explain myself.

I want the subform to be hidden unless a button is clicked that makes it appear.

Thanks

 

[pbaldy]

Me.SubFormControlName.Visible = True

 

[Carl Foster]

Oh I see

Try this code then in the click event of the button:

If fsub1.Visible = False Then
fsub1.Visible = True
Else: fsub1.Visible = False
End If

Just substitute the "fsub1" for the name of your subform.