Changing embedded Subforms within a Form

[Lochdanon]

Is it possible to change embedded / nested subforms from within a form? I'm going to try to explain this (at least what I see in my head). If you have a series of buttons in the main form linked to different subforms and press anyone of these buttons, can the subform be changed out from the last subform.

ie : button1 button2 button3 button4 .... etc.

(Subform Area is here)

Subform 1 is linked to button 1 ... etc.

If I press button 3 then Subform 3 will take the place of subform 1 in the Subform Area and vice versa.

Does that make sense? I think I'm asking Access to do to much.

Any help / critisism would be appreciated.

Thanks

 

[kbrooks]

Funny, I was just coming on here to search for a similar question. Another route I thought of going was having ONE subform, but having different fields visible/invisible depending on the selection made in a combo box on the main form.

 

[Lochdanon]

Thanks Pat,

I completely overlooked that feature on the toolbar ... looking to make a mountain out of a mole hill I guess ...

Thanks again.