Display Subform Based Upon Option Button Selection

[Bcanfield83]

I have a form that contains 2 option buttons (radio buttons) within the header section. These are part of an Option Group - so the option values are simply "1" or "2" depending on which button is selected.
In the main 'detail' section of the form is a Subform Container called "SubformContainer" (real creative I know).
I'm trying to design it so that, depending on which of those 2 option buttons is selected, the appropriate form will be displayed in that Subform Container portion.


This seems fairly simple, but for some reason it's not working.. No matter which option button is selected, the detail section of the form is blank.
Thoughts?

Private Sub frameProjectOptions_AfterUpdate()


Select Case Me.frameProjectOptions.Value


Case 1
    Me.SubformContainer.SourceObject = "frmEDG_Project_Management_Subform_New"
Case 2
   Me.SubformContainer.SourceObject = "frmEDG_Project_Management_Subform_All"


End Select




End Sub

[orange]

I suggest you post a copy of your evolving database so readers can see what you are dealing with.

[isladogs]

As an alternative I suggest you have two subforms placed in the same location and both hidden by default.
Then make the relevant form visible depending on the option clicked

[Bcanfield83]

As an alternative I suggest you have two subforms placed in the same location and both hidden by default.
Then make the relevant form visible depending on the option clicked

Thanks - that worked.

[isladogs]

You're welcome