Referencing a Control on an Access 2010 Navigation System

RayMilhon

New member
Local time
Today, 07:08
Joined
Dec 17, 2010
Messages
5
I have an Access 2010 Database frontend to SQL Server 2008 Backend. So far there are 3 Tabs in the Navigation System.
The first one is the primary Data Entry form which has a tab control with 3 subforms.

Here's the problem. The database is designed to track potential members based on different types of Ads. The primary Data Entry form holds all of the demographic data for the person that called in response to an ad. The first tab has a subform to track how many times that person has contacted us. The second subform tracks which advertisements the person is contacting us about and the third tracks which Events that person attended. There is no correlation between contacts, Ads and Events. On the Advertisements we have about 7 different types of Ads we do and each ad can be run multiple times on different days. We want to be able to track which Ad the person contacted us about. The Advertisement subform has a comgo box for the Ad type and a combo box for the ad date. the source for the combo box for the ad date includes the combobox for the adtype as the criteria. That criteria is what's giving me the problem. I've used:

forms!mainmenu!navigationsubform.form!potential_members!frmAdvertisements!cboadvid

along with every other variation I can think of. The form itself is frmAdvertisements but I'm using it in a tab control and I also tried
forms!mainment!navigationsubform.form!potential_members!adv!cboadvid

Any thoughts?
 
In the criterion field right-click to invoke the expression builder. There, navigate to the control in question (in open forms) and click paste.
 
Navigation forms are a nightmare to work with. It wasn't built for Data Entry on multiple forms, it's best for viewing data on read-only forms or mainly as a switchboard.

You will find that switching between tabs causes data to refresh which isn't ideal if you're working on one form and switching to another to perhaps view data. This is because the navigation subform is just one subform and the SourceObject (or whatever it's called in Access) gets swapped around when you switch to a different tab. Not ideal!

You're better off using a Tab Control and embedding your subforms into each page.
 
spikepl: Can't do that the source of the combobox I'm using is a query. The criteria I'm looking for is in the Where clause of the query

vbaInet: Can't do that either as the subforms are in a tab control on the data entry page. The other pages on the Navigation form are for Reporting and maintaining the lookup tables on the data entry page. I've used this system before and it worked well. The difference this time is one of the combo boxes is based on a query to look up values in a different table and has to use the data from a different combo box. I've not done that before with the navigation system but I have done it without the navigation system and it worked well. the issue I'm having is the syntax to reference that other combo box using the navigation system.
 
Can't do that the source of the combobox I'm using is a query. The criteria I'm looking for is in the Where clause of the query
And ? Nothing there prevents anyone from clickng in the criterion field in the query designer to invoke the expression builder. The query designer doesn't give a damn whether the query is used in a combo or wherever.
 
I've not done that before with the navigation system but I have done it without the navigation system and it worked well. the issue I'm having is the syntax to reference that other combo box using the navigation system.
This is precisely why I'm telling you that you that you should move away from the navigation form and re-think the layout of your forms. For example, if you were on Tab 1 on the navigation form and wanted to get data from Tab 2, you will not be able to do so because that form/subform/query isn't loaded. This is how the navigation form works. Navigation forms were made with Web users in mind.

My advise to you is re-think your form layout!
 
And just for your reference:
Code:
Me.NavigationSubform![COLOR="Blue"]SubformControlName[/COLOR]![COLOR="blue"]ComboBoxName[/COLOR].Value
 

Users who are viewing this thread

Back
Top Bottom