How to Reference Navigation Subform Objects

[altemir]

I have an Access 2010 database with a navigation subform, but I'm never quite sure how to reference objects in other forms contained with the Navigation Subform. Please help!!



For example, if:

frmMain = main form
NavigationSubform = navigation subform container
frmEmployees = form contained within NavigationSubform

How do you reference the following objects in frmEmployees?

-- a form control
-- the form object itself to support a method
-- a subform with frmEmployees

Here are my best guesses, but I don't think these are correct:

Form control: Forms!frmMain!NavigationSubform!frmEmployees.Form! txtEmployeeID

Form itself: Forms!frmMain!NavigationSubform!frmEmployees.Form. Requery

Subform: Forms!frmMain!NavigationSubform!frmEmployees!subfr mPayments.Form.Recordsource

Any help would be appreciated!

[pbaldy]

See if this helps:

Forms Refer to Form and Subform properties and controls

You use the name of the container, not the name of the form within.

[altemir]

Thanks, Paul. That was helpful but it didn't quite address the issue because it doesn't go far enough for my application. The example you cited involves a Mainform, Subform1, and Subform2. I need to build a reference that addresses Subform3 as I have a subform within the form that is in the NavigationSubform.

Any suggestions to define a Recordsource and issue a Requery for this fourth level of subform?

[altemir]

I figured it out!

Forms!frmMain!NavigationSubform.Form!subSearchJobs .Form.RecordSource

or, more generically:

Forms!Mainform!Subform1.Form!Subform3.Form.RecordS ource

I guess I'm surprised that Subform2 is not included and I don't understand why not, but it works :-)

[pbaldy]

Glad you got it sorted out. Subform2 must not be involved. In any case, the same pattern would be used, just another level deeper.

[SmartestIdiot]

I know this is an old thread, but your post is the closest solution to my problem however I can't seem to make it work.
Main form = Navigation Form
Subform = Navigationsubform
Form = subAwards

When I try your solution, MS can't find subAwards

This is what I've tried: Forms![navigation form]![NavigationSubform].Form![subAwards].Form.
[List370].Requery

I'm trying to reference the listbox to refresh it. It only is on the subAwards form.

[SmartestIdiot]

By the way. I can get it to work on just that one form if I take out the [subawards], but then when I go to the other forms I get the debug