How to open a subform using a button?

  • Thread starter Thread starter chill
  • Start date Start date
C

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Main Form and two Subforms 2
Using an append query in a subform 1
Open a form in a subform depending on button. 1
Search criteria not passing to subforms 2
Go to a Specific Record on a Subform 3
New Parent Record from Navigation Buttons 2
Do not run subform criteria when form opens 1

Back
Top