Navigation forms

liamfitz

Registered User.
Local time
Today, 05:03
Joined
May 17, 2012
Messages
240
Is there a reliable reference, for referencing 'subforms' values/controls therein. The following doesn't work
Code:
If Forms!frmNavigationLeft.Form!NavigationSubform.Form!frmClients.Cnam <> "" Then

As you can see I'm trying to check a Public variable (Cnam) on a subform. I have a navigation form (frmNavigationLeft), 'on' which is another navigation form ( frmNavigationTop) 'under' these nav. buttons I have several forms. how do I erefr to controls/values I know there's a particular format, but it's not quite right. Any help appreciated. thanks.:confused:
 
If you have left the standard naming of the navigation control subforms then:

Forms!frmNavigationLeft!NavigationSubform!NavigationSubform!Cnam
 
Thank you for your prompt and helpful response.
 
That works well, but I can't figure out, how to pass a vaule from a field on a subform of that Form i.e I have a subform on the last Form referred to in your command
Forms!frmNavigationLeft!NavigationSubform!NavigationSubform!sfrmReferrals.Referral_ID

I have put a field, which is on the mainfrom, instead of 'sfrmReferrals.Referral_ID' this works, but as you see I also wish to take a value from the subform( field = Referral_ID ), and the above syntax is wrong. Any help much appreciated.
 

Users who are viewing this thread

Back
Top Bottom