How to open a subform using a button?

[chill]

hi

im trying to open a subform using the "open form " button from the main form .
Is there any way to do this?

thanks

 

[Jeanette Cunningham]

Hi chill,
when the form opens, the subform control (that holds the subform) can be
empty.
Your button can open the subform like this-->
Me.NameOfSubformControl.SourceObject = "NameOfSubform"

You can also have the subform already loaded and just toggle it's visible
property.

Note: Use your names for NameOfSubformControl and NameOfSubform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia