Open a Subform Based on the Current Record
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
Code:
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!