Programmatically open a form in tabbed mode - Access 2007

[Silvio]

Here is my question: I am using the contacts database template from Access
2007. This database has two forms: “Contact List†and “Contact Detailsâ€. The
“Contact List†has an “Open†command for each contact in the list; this
command when clicked will open the “Contact Details†for that specific
contact. By default the “Contact Details†opens in pop-up mode. How can I
force it to open the form in tabbed mode instead? The database property is
already set to tabbed mode and I have changed the macro behind the “Openâ€
command to read: Contact Details, Form, , ="[ID]=" & Nz([ID],0), , Normal.
Also, I sat the “Contact Details†form property Pop Up = No. In addition, I
noticed that if I first open the “Contact Details†from the navigation pane
it opens in tabbed mode, and then if I open the “Contact List†and select an
item from the list, access will focus on the “Contact Details†form, selects
the appropriate contact and the form stays tabbed.

 

[ruralguy via AccessMonster.com]

Try changing the WindowMode from Dialog to Normal.

Here is my question: I am using the contacts database template from Access
2007. This database has two forms: “Contact List†and “Contact Detailsâ€. The
“Contact List†has an “Open†command for each contact in the list; this
command when clicked will open the “Contact Details†for that specific
contact. By default the “Contact Details†opens in pop-up mode. How can I
force it to open the form in tabbed mode instead? The database property is
already set to tabbed mode and I have changed the macro behind the “Openâ€
command to read: Contact Details, Form, , ="[ID]=" & Nz([ID],0), , Normal.
Also, I sat the “Contact Details†form property Pop Up = No. In addition, I
noticed that if I first open the “Contact Details†from the navigation pane
it opens in tabbed mode, and then if I open the “Contact List†and select an
item from the list, access will focus on the “Contact Details†form, selects
the appropriate contact and the form stays tabbed.