Navigation Form

[rkalapura]

Hai Everybody,
I have gone through many threads related to the Navigation form problems to sort out my problem but could not work out. I have arranged all my forms and reports through switchboard and now like to transfer to Navigation form. I have almost 35 forms and much more reports to put in to the Navigation form. Allmy forms are filled with many informations through IIF(), Dlookup() and controls with macros. These are the important informations for the users for right data entry and it helps them a lot. When I drag my forms into Navigation form, all these fields which shows the informations from other table fileds doesn't work, showing "Name?" or "Type?" etc. I tried to give the path in different ways, I dont know. I may be lost in Child-Parent relationship.


My Navigation form name is "Main Navigation". The Main tabs on the top side is "Forms", "Reports", "Tooling", "Machines", "Technicians" etc. etc. Under each of these main tabs, I have different subtabs. Like under "Forms", I have "Register Oparation1", "Register Oparation 2", "Register Opration 3" etc. etc. The actual form names draging and droping on these sub tabs are "Face Grind" form, "OD Grind" form, "Bore Grind" form etc. Appreciate your help for correcting the control source property of these Dlookup() fileds, showing the correct parent-child relationship.
Thank you for your time and best regards.

[June7]

I started using Access 2010 few months ago. I examined the new Navigation form and considered it nothing more than a wizard to build a tab control with subforms on the tabs. I don't like wizards (I don't want macros and forms/reports designed with wizards are harder to edit). I would use the old Tab and Subform container controls and manually build this arrangement.

all these fields which shows the informations from other table fileds doesn't work

Are you referencing the table or the form that has the table as RecordSource? If you are referencing the form, when you put forms into a subform container control, these references must be modified to consider the container control. The syntax would be: mainformname.containername.Form.controlname

[rkalapura]

Thanks for the reply.
I am just giving below the control source property of one fileld for a sample.

=DLookUp("[WIDTH MAX]","[PARTS]","[PART NO]='" & [Forms]![JOB REGISTER B]![PART NO] & " ' ")

It gives me the information of Width from Parts Table of whatever part number I am entering in to the form JobRegisterB. This way I am displaying many infos of the same part number in the form JobregisterB all in separate fields.

Can you please tell me, when I drag and drop this form JobregisterB to Navigation form sub control "Register Oparation2" in the Form Menu, what changes I need to make on this Dlookup(). I dont really understand the container control. Once you show me the full reference, I am sure I can pick up.
Thanks once again for your help.

[June7]

As I suspected, you are referring to the form and this syntax will no longer work when forms are in subform containers. Try:
[Forms]![Menu]![subformcontainername]![Part No]

I always give the container a name different from the form it holds, like ctrJobReg