Refer to a control on a subform on a Navigation Subform

[Snowflake68]

I have several tabs on my Navigation form which is on a main form called frmMain.

I am trying to refer to a control called cboCustomer which is on a subform that is a subform of the Navigation form but I just cant get the correct syntax. I have tried using the syntax below because I just dont know how to tell it to refer to another subform which is two further layers down. I recall reading that I do not need to refer to the actual subform directly on the navigation form but I just cannot get it to work.

[Forms]![frmMain]![NavigationSubform].[Form]![cboCustomer]

Main form - frmMain
Navigation form -NavigationSubform
Source of one of the tabs is sfrmDS_Section_2 and its subform is called DS
Control is called cboCustomer

I hope someone can put me out of my misery because I have been trying to sort this for hours now.

 

[Ranman256]

If all your names are correct,then that should work.
Use the BUILDER. It always gets the path correct.

 

[Snowflake68]

If all your names are correct,then that should work.
Use the BUILDER. It always gets the path correct.

I tried using the builder but that didnt help at all. I made sure all my forms were loaded but the DS one just doesnt appear. :banghead:

 

[JHB]

Post your database with some sample data.

 

[Snowflake68]

Ive solved it.

This is the SOLUTION I needed.

[Forms]![frmMain]![NavigationSubform].[Form].[Controls]![DS].[Form].[CboCustomer]

I can sleep easier now

 

[Snowflake68]

Post your database with some sample data.

Thanks for your kind offer to help me but I've managed to sort it out myself in the end.

 

[Minty]

It's a problem with the inbuilt navigation forms. Have a read here https://www.access-programmers.co.uk/forums/showthread.php?t=286675

 

[Snowflake68]

It's a problem with the inbuilt navigation forms. Have a read here https://www.access-programmers.co.uk/forums/showthread.php?t=286675

Thanks but I have solved it now and also marked the post accordingly. Interestingly enough I did read the post you pointed me at but I just got even more confused so I created my own post. Anyway all sorted now thanks Minty

 

[Minty]

NP - thought I would link back to that as it provided some solutions as well as what didn't work. Glad you are sorted out.