Navigation Form referencing ?

[liamfitz]

With Access 2010's new 'Navigation Forms'- the usual hierarchical referencing of forms, does not work. For example, where one wishes to refer to a variable/control on a sub-form, NOT IN THESE FORMS, one might program as follows : With Forms!frmClients!sfrmReferrals.Form.NAMEOFVARIABLE/CONTROL. This works fine, UNTIL, you incorporate your main and Subform into a Navigation Form. Can anyone help ?

 

[JANR]

Does this help: http://www.utteraccess.com/forum/Navigation-Form-t1994410.html

JR

 

[boblarson]

Does this help: http://www.utteraccess.com/forum/Navigation-Form-t1994410.html

JR

Good one. I've bookmarked that one for sure, and with AccessJunkie answering - he's directly involved with the Access development, not a better source.

 

[liamfitz]

It looks as though it may very well help. Many thanks. I'll try it at work tomorrow. I'm at least assured there is a way to do it ( as I thought there must be ). Having read it, it reads like a 'Control Source' for an object on 'another' form. I can write my VBA to cater for this, ( maybe put an invisible Text box on the other form - then reference that, easily as 'Me.TextBox.Text or Value, or whatever ), but I was hoping to work out, or be informed of, what the VBA itself would be, from another form not on the navigation form. Maybe if I drop the square brackets, and insert into source code, it looks more like the referencing forms/subforms I tend to use. Thanks again, your support is v. much appreciated ( vital in some cases ! ).