Overlapping subforms - bringing any one to "top of the stack"

[Walt in Decatur]

I have set up a bunch of subforms to appear in the same spot on the screen relative to the main form. I have set up command buttons with open and close each subform. However, if I have several open at the same time, only the one that is "later" in the order of controls shows, the others sit underneath and one can't set focus on them.

First question. Design-wise, I like the way I've set this up, as one can expect a subform to always pop up in the same spot. But is this a good idea?
Second question. What would be the code for a command button to bring any particular subform to the top, in front of others? Can this be done easily regardless of how many subforms are open at any given time?

Thanks, oh wise Access gurus!

[ADezii]

I have set up a bunch of subforms to appear in the same spot on the screen relative to the main form. I have set up command buttons with open and close each subform. However, if I have several open at the same time, only the one that is "later" in the order of controls shows, the others sit underneath and one can't set focus on them.

First question. Design-wise, I like the way I've set this up, as one can expect a subform to always pop up in the same spot. But is this a good idea?
Second question. What would be the code for a command button to bring any particular subform to the top, in front of others? Can this be done easily regardless of how many subforms are open at any given time?

Thanks, oh wise Access gurus!

Let's assume you have 6 stacked Sub-Forms, and you wish to view SubFormTwo. Just set its Visible Property to True and the rest to False, something similar to the code below:

'Want to view SubFormTwo
Me!SubFormOne.Visible = False
Me!SubFormTwo.Visible = True
Me!SubFormThree.Visible = False
Me!SubFormFour.Visible = False
Me!SubFormFive.Visible = False
Me!SubFormSix.Visible = False

[JKing]

If you don't need more than one of the subform open at any one time you could just as easily flip the sourceobject each time you want a different form to appear. This means only having one subform pane on your main form instead of stacking 6 subforms on the same form. All you would have to do is put the correct subform name in for each button click event.

Private Sub cmdSubForm1_Click()
Me.sfrm.SourceObject = "sfrm1"
End Sub
 

[Walt in Decatur]

Bingo! Thanks!

This is the way I chose to implement it (now that I got back to working on my form). I think it's the simplest way, indeed. I probably should have thought of this in the first place, but I'm still learning how to exploit properties of various controls to my advantage. Not having any formal training makes for interesting adventures in coding. :-)

If you don't need more than one of the subform open at any one time you could just as easily flip the sourceobject each time you want a different form to appear. This means only having one subform pane on your main form instead of stacking 6 subforms on the same form. All you would have to do is put the correct subform name in for each button click event.

Private Sub cmdSubForm1_Click()
Me.sfrm.SourceObject = "sfrm1"
End Sub