[RESOLVED] [VBA] Open Form in SubForm [Urgent]

[emdiesse]

I have a form called frmIndex with a form header, detail and footer.
The header just contains a logo and title, the footer contains nothing.
The bit I am focused on though is the detail section which contains a subform (the subform has the name: IndexFrame), which is currently displaying frmLogon within it.

when the user clicks a button I want IndexFrame to change its SourceObject from frmLogon to frmMenu.

How do I alter this to do what I am aiming to acheive:

Private Sub Command11_Click()
    Dim Index As New Form_frmIndex
    Index.IndexFrame.SourceObject = frmMenu
End Sub

Why doesn't that work, seems right to me? I also tried it with frmMenu in "" No luck

Thanks, Emdiesse