Open form in the navigationsubform window

[ahmed_optom]

Hi guys,

Im just trying to open a form in the navigationsubform space, just like a navigation button would do.


I was hoping there would be a simple parameter like target=, but i cant seem to find any such thing.

Any ideas?

thanks,

 

[theDBguy]

Hi. Have you tried using the BrowseTo method?

 

[ahmed_optom]

yes thanks, I got it working now.

Heres the code I used in the end, the syntax is really different to standard access/vba , so becareful

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="Form_Name", _
PathToSubformControl:="Main Menu.NavigationSubform", _
DataMode:=acFormEdit

 

[theDBguy]

yes thanks, I got it working now.

Heres the code I used in the end, the syntax is really different to standard access/vba , so becareful

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="Form_Name", _
PathToSubformControl:="Main Menu.NavigationSubform", _
DataMode:=acFormEdit

Hi. Congratulations! Glad to hear you got it to work. Good luck with your project.