Display different form in a subform based on command button...

[scottmfitzge]

Hi Guys, I am stuck on a subform problem in my DB - I would like to do something but not sure if it is possible - if someone is able to point me in the right direction i would really appreciate it. I would like to set up a subform on the main form of my DB and four command buttons, then dependent on which command button is clicked, i would like a different form to be displayed in the subform. I have created the four forms and placed the four buttons on the main form. I have also created a subform on the main form using the control toolbox - any ideas how i make this work?? Really appreciate any help you can give me here... Thanks Guys...

 

[ErikSnoek]

On the On Click event of your button add:

Name_Of_Your_Subform_Control.SourceObject = "Name_Of_Your_Subform"

 

[scottmfitzge]

Thanks very much - that works perfectly....