Accessing Controls within a NavigationSubform

[kewelch]

Hi,

I'm having issues with getting data off a combo box within a NavigationSubform in order to create the Row Source of another combo box within that same form. I Have a menu form called MainMenu and am trying to pull data from an unbound combo box named CustomerSelectcbo which is opened in the NavigationSubform. The name of the form opened in this fashion is POMultipleInfoForm. The following paths do not work.

[Forms]![MainMenu]![NavigationSubform]![CustomerSelectcbo]
[Me]![NavigationSubform]![CustomerSelectcbo]


[Forms]![MainMenu]![NavigationSubform]![POMultipleInfoForm]![CustomerSelectcbo]

All help and advice is welcome, thanks

[ketbdnetbp]

kewelch -

Usually, the syntax is:

[Forms]![MainFormName]![SubformName].Form![NameOfControl]

So, I would try...

[Forms]![MainMenu]![POMultipleInfoForm].Form![CustomerSelectcbo]

Change the names of the forms if the above is incorrect.

All the best,

Jim

PS - A link that might be useful...

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

[kewelch]

Hi Jim,

I tried that line as the row source for the second combo box, and this also does not work. When I requery it after selecting a customer from CustomerSelectcbo, a dialog box pops up titled "Enter Parameter Value" asking for...

Forms!MainMenu!POMultipleInfoForm.Form!CustomerSel ectcbo

The CustomerSelectcbo is formatted correctly with the ID key in the first column, so it should be reading in the ID. The odd thing about this, is as I type in the row source it can auto complete [NavigationSubform] after [Forms]![MainMenu]!. The MainMenu is a Navigation Form, which is a feature added in Access 2007 (are you using 2003 as your profile says?). I can't find good documentation on using this form.

[ketbdnetbp]

kewelch - A couple of questions...

What is the name of the form where [CustomerSelectcbo] resides? Is it NavigationSubform?
Is the second combo box on another subform named [POMultipleInfoForm]?
What is the exact rowsource for the second combo? (copy/paste)

Let me know...

Jim

[kewelch]

Thanks for the reply.

CustomerSelectcbo is in the form POMultipleInfoForm. NavigationSubform is the name of the subform created
by the navigation form MainMenu, but it brings up POMultipleInfoForm off a NavigationButton.
The second combo box is in the header of POMultipleInfoForm which is a continuous Multiple Items form.
It is currently...

[Forms]![MainMenu]![NavigationSubform].[Form]![CustomerSelectcbo]

This is similar to your previous suggestion, but in the row source query builder, it can auto complete this entire line
after each ! or .

[ketbdnetbp]

kewelch -

Bear with me as I am having difficulty envisioning your set-up.

Is the form [POMultipleInfoForm] a subform?

Try each of the following...

Me![CustomerSelectcbo]
or,
Me.Parent![CustomerSelectcbo]
or,
Me!POMultipleInfoForm.Form!CustomerSelectcbo
or,
Me!MainMenu.Form!POMultipleInfoForm.Form!CustomerS electcbo

If the above doesn't work, you may have to provide db for analysis. (Compact/Repair, zip, use attachment manager under Go Advanced button below.)

Jim