Open a Subform Based on the Current Record

[Mattheus]

Users navigate through my database with a navigation form. I want to have a button that opens a different subform based on the current record. I can get the main version of the form to open with the OpenForm command like so

DoCmd.OpenForm "FormName", , ,"RecordID = " & Me.RecordID

However, I can only get this to open the main form. I can't seem to figure out the syntax to have Access open the form as part of the navigation form. The only solutions I've been able to find don't relate to navigation subforms.

Thanks in advance for any help or advice!

[OBP]

The subform should be on the mainform and use Master/Child Links to display the same record.

[Uncle Gizmo]

Re >>>The only solutions I've been able to find don't relate to navigation subforms<<<


I have no experience with navigation forms because I was always advised never to use them! I think this is what you have discovered, they don't work well with Code. Could you change over to the normal Subform/Subreport Control arrangement?

[Mattheus]

Looks like that will be the only option. Thanks for the assistance!