ahmed_optom
Registered User.
- Local time
- Today, 16:25
- Joined
- Oct 27, 2016
- Messages
- 93
There appears to be a weird issue with the browseto command.
If I use it in isolation, it works as expected. If the same browseto comes after any vba that includes the use of "set", then it gives a runtime error 6054.
my browseto code is as below:
DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="Existing Patients", _
PathToSubformControl:="Main Menu.NavigationSubform", _
WhereCondition:="", _
Page:="", _
DataMode:=acFormReadOnly
my googling on this issue found someone in 2014 with the same issue
Does anyone know more or a way around this?
I have tried moving code into functions, but as expected, this did not help.
if I change the order of the code, that particular runtime error goes away, but the form breaks for other reasons, eg moving away from the form whilst other code is trying to reference it.
Any thoughts ?
If I use it in isolation, it works as expected. If the same browseto comes after any vba that includes the use of "set", then it gives a runtime error 6054.
my browseto code is as below:
DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="Existing Patients", _
PathToSubformControl:="Main Menu.NavigationSubform", _
WhereCondition:="", _
Page:="", _
DataMode:=acFormReadOnly
my googling on this issue found someone in 2014 with the same issue
DoCmd.BrowseTo statement produces strange PathToSubformControl error
Background: I'm working on a project that relies on 21 different lookup tables for basic data used throughout the rest of the application. As part of my user interface, I intend to expose these lookup tables to the user through forms to allow for modification of the data. I have created a...
www.accessforums.net
Does anyone know more or a way around this?
I have tried moving code into functions, but as expected, this did not help.
if I change the order of the code, that particular runtime error goes away, but the form breaks for other reasons, eg moving away from the form whilst other code is trying to reference it.
Any thoughts ?