Is it possible to have a combo box determine what subform to open on parent form?

Eg.  RequestF contains requesttypecombo. then you have a subform on the requestF.

You have 3 subforms (New, Terminate, NameChange). If I choose terminate from the combobox on the requestF, can you write code so that the correct subform (terminate sub form) opens in the requestF.

---

Reply from Alex Hedley:

You can set the SourceObject of a SubForm in code.
Me.CONTROLNAME.SourceObject = "FORMNAME"

When you drag your SubForm onto a Form get the NAME of it.
Change CONTROLNAME to the above NAME.
Now use the name of the Form in the NAVIGATION PANE to be the "FORMNAME"

You change set this in your AfterUpdate event on the Combo.