I'm using Access 2010. We had 2 separate Databases each with a Navigation subform with 3 to 4 tabs. Our member services group had one and our Senior Programming group used the other. it later came up that our member services group needed read only access to the senior programming db. Since both Databases are located in SQL Server and the front end is in MS Access I gave the member services group read only access to the data in sql server and then created a Senior programming tab in their databases copying all of the forms and Navigation menus to their front end and giving them the senior programming navigation menu on that tab. The issue is that one of the forms in the senior programming level has 2 subforms and one of those subforms has a combo box based on a query with one of the parameters set as the other combo box on that form. Works perfectly in the Senior programming but I don't have the correct syntax to reference that combo box correctly it keeps prompting me for the data.



Here's the syntax from the senior programming DB

[Forms]![frm_mainMenu]![NavigationSubform].[Form]![frm_people_event]![cbo_event].[Value]


Here's what I tried in the member services DB

Forms!mainmenu!navigationsubform.Form!frm_SP_mainm enu!navigationsubform.Form!frm_people_event!cbo_ev ent.Value

I put the _SP_ into the form name so I or anyone coming after me would know that's part of the Senior Programming menu.

I know I've got the syntax wrong just not sure where I'm off.