I am using the Navigation Control in a medium-sized application with a fair amount of complexity. I am having trouble with the BrowseTo method. It returns no data when I add a WhereClause. My code looks like this:
Dim lngEntity As Long
lngEntity = [Forms]![SiteNavigation].[NavigationSubform].[Form].[apd__entity__entity_id]
DoCmd.BrowseTo acBrowseToForm, _
PathtoSubformControl:="SiteNavigation.NavigationSubform>Snapshotseries Navigation.Navigationsubform", _
WhereCondition:="[apd__entity__entity_id] = " & lngEntity
I have validated that lngEntity contains the correct value.
Any suggestions would be appreciated!