DoCmdBrowseTo - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DoCmdBrowseTo

Juan C Rivera

3 years ago

Saw this today so I looked it up and it gave this as an example

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="EventDS", _
PathToSubformControl:="Main.NavigationSubform", _
WhereCondition:="", _
Page:="", _
DataMode:=acFormEdit

Was this covered in any lesson? I like to review I do not recall and the sample that was provided is not clear to me.
Any pro/cons on this?

V/r
Juan

	Kevin Robertson @Reply 3 years ago
This can be simplified (I never use that syntax). Using the parameters in your example: `DoCmd.BrowseTo acBrowseToForm, "EventDS", "Main.NavigationSubform", , , acFormEdit`

	Juan C Rivera OP @Reply 3 years ago
OK any thoughts on pro, con?

Kevin Yip @Reply

3 years ago

Richard probably won't teach this, because DoCmd.BrowseTo is most often used in navigation forms, and Richard has navigation forms on his Evil Access Stuff list. I've never used them, as navigation forms didn't exist when I started using Access in the 90s. They may be useful if you want to design forms that look like web pages (see pic below). It's called "BrowseTo" probably because it lets you mimic the interface of a web browser, i.e. with tabs and pages.

	Kevin Yip @Reply 3 years ago

	Juan C Rivera OP @Reply 3 years ago
Thanks guys

	Richard Rost @Reply 3 years ago
I've actually got a video on BrowseTo coming up. And yes, you can simplify those parameters. The "ObjectType:=" for example, is optional. Kinda. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View