Access 2010 - Navigation Forms (how to reference a control)

[AccessCalderCreative]

Hi all!

I love the new navigation form functionality in Access 2010, however am having problems referencing a control within the subforms.

I have 10 navigation buttons on the parent form, each with a subform. I desparately need to be able to reference controls within each subform, however am struggling with the syntax.

I have tried the following code:
[Forms]![frmParentform]![frmNavigationsubform].[form].[cboControl]
which works beautifully for the first subform (ie. Tab Index = 0)

However, I am stumped as how to reference a control on any of the other 9 subforms (ie Tab Index - 1-8) as the aforementioned syntax doesn't work for any of them but the first (ie Tab Index =0).

Any ideas would be most welcome and thank you all in advance!!!

Cheers
Grateful down under user

 

[vbaInet]

Don't worry about the tab or pages, just reference the other subforms as you've already done. Did you try it already?

 

[AccessCalderCreative]

Hello and thanks for your speedy response!

Yes I have tried it and I simply cannot get it to work for any other form except for the first one, which is why I mentioned it (thought it may be relevant?).

Any ideas?

Cheers

 

[AccessCalderCreative]

Ignore my last response! It wasn't working on one particular form for some reason but I'm able to get it working on others, so please don't worry.

Thank you again for your reassurance as it made me re-check and I have solved it.

Cheers
CC.

 

[vbaInet]

It was probably just a typo in the subform control name.

Glad that's sorted.

 

[jcruzAME]

I'm currently working on a problem similar to this. What exactly did you do to fix your problem? I can't seem to access anything except the first form as you stated. I have frmMainMenu (the navigation form) and several tabs. The only one I can access from my MainMenu is subfrmHome. For any of the others it says it can't find the field subfrm(whichever one i'm looking for).

 

[liamfitz]

I can't get mine to work, using the same logic/hieracrchy. I note you put your objects in square brackets []. Are you using these lines of 'code' in the control source of objects, or actually writing VBA code using this syntax ? Thanks.