Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA to open a Navigation Form subform
You asked about the name of my main form and subform. I actually did use them. I simply kept the Default Name of "Navigation Form" and "NavigationSubform" for the container. It helped to keep things simple until I'm more familiar with the Navigation Form. The odd thing about it was that even...- jgm835
- Post #7
- Forum: Microsoft: Access Forms
-
VBA to open a Navigation Form subform
I finally answered my own question with the correct parameters in the DoCmd.BrowseTo command as follows: DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ ObjectName:="frmBatesFiles", _ PathToSubformControl:="Navigation Form.NavigationSubform", _ DataMode:=acFormEdit The...- jgm835
- Post #4
- Forum: Microsoft: Access Forms
-
VBA to open a Navigation Form subform
Thanks for the reply. That probably works in subforms for regular forms but I haven't been able to get it to work in the new Navigation Form with Access 2010. I had tried that from code in both command buttons and the load and open events of the Navigation Form. It does not compile. The...- jgm835
- Post #3
- Forum: Microsoft: Access Forms
-
VBA to open a Navigation Form subform
I have several subforms in a Navigation Form in Access 2010. I know I can reference and retrieve the subform name currently open with Forms![Navigation Form]!NavigationSubform].[Form].Name, but it is a read only property. I want to programmatically switch or open one of the subforms from...- jgm835
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
