Header Combo Box/Navigation Form Question

[jcruzAME]

Maybe this is better suited to the Queries section.

Okay, so I have a navigation form called MainMenu. MainMenu has a header with log in information of who's logged in an also a combo box.

I have several tabs on the Navigation Form, one of which has a combo box that will refer to the selected option in the combo box on the header of MainMenu.

I've been searching for awhile and can't find any good information when dealing with Navigation Forms.

To sum up, when I select a value in the MainMenu combo box that's in the header, I want to re-set the row source in the combo box on the subform of one of the navigation tabs.

Any help? Is this even possible?

 

[jcruzAME]

Okay so here's what I've been trying.

Me!subfrmTab2.Form.cboSecondCBO.RowSource = ""

and

Forms.frmMainMenu.subfrmTab2.Form.cboSecondCBO.RowSource = ""

Any of these I try to do I get the error that it can't find the field subfrmTab2.

It will work on the first subfrm though, tab index 0.

 

[vbaInet]

Navigation Form is a 2010 concept isn't it? I have the CD but just haven't had time to play with it.

You can try:

Forms[COLOR=Red]![/COLOR]frmMainMenu[COLOR=Red]![/COLOR]subfrmTab2.Form.cboSecondCBO.RowSource = ""

 

[jcruzAME]

Forms!frmMainMenu!subfrmHome.Controls!lstNetWorth.RowSource

Here's the code that is in there now.

Here's what happens:

When I first open the program, the Home tab is what is displayed. If I change the combo box in the header of frmMainMenu, it will work.

If I try put code that tries to access subfrmClient that is another tab, it says it can't find subfrmClient.

If I'm on subfrmClient and change the combo box value in the header of frmMainMenu, it doesn't say it can't find subfrmHome, it says it can't find the control lstNetWorth.

So I'm not sure what the structure is.

 

[vbaInet]

Here's the code that is in there now.

Where's the code?

 

[jcruzAME]

Sorry, should've said "That's the code that's in there now."

It's the first line of that post.

 

[vbaInet]

If I try put code that tries to access subfrmClient that is another tab, it says it can't find subfrmClient.

If I'm on subfrmClient and change the combo box value in the header of frmMainMenu, it doesn't say it can't find subfrmHome, it says it can't find the control lstNetWorth.

These are referencing issues. Have a look at this link on form referencing:

http://access.mvps.org/access/forms/frm0031.htm