Link subform in Navigation form with main form

[tihmir]

I have to link to 3 subforms on Navigation form "NavForm" to main form "Inspection" because link Master link to Child Link is not allowed for unbound forms. The field name on subform "Products" is "InspectionID", same as the field name in the main form "Inspection". How to link them?

 

[theDBguy]

Hi. Have tried simply typing in the field names in the link fields? Don't use the builder.

 

[tihmir]

Hi. Have tried simply typing in the field names in the link fields? Don't use the builder.

I have tried, but it show me "Can't build a link between unbound forms".

 

[theDBguy]

I have tried, but it show me "Can't build a link between unbound forms"

Then, you may have to do it with code when the subform gets loaded.

 

[tihmir]

Then, you may have to do it with code when the subform gets loaded.

Oh, sorry. I type Master link field "InspectionID" and Child link "Inspection" it does nothing. No reaction. I want to mention that the subform "Inspection" is into in Navigation Form (which is not Main form) on "NavigationButton7"

 

[theDBguy]

Oh, sorry. I type Master link field "InspectionID" and Child link "Inspection" it does nothing. No reaction. I want to mention that the subform "Inspection" is into in Navigation Form (which is not Main form) on "NavigationButton7"

Well, if you're using a true navigation form, I am not sure there is a link fields properties because the subform gets loaded dynamically. I'll have to check it when I get in front of a computer.

 

[June7]

So you have a subform within a form on a Navigation Form tab? I am able to do this and set Master/Child links. However, I never use Navigation Form.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[theDBguy]

Well, if you're using a true navigation form, I am not sure there is a link fields properties because the subform gets loaded dynamically. I'll have to check it when I get in front of a computer.

Okay, I just checked this and a Navigation Subform does not have a linked field because it gets a different sourceobject based on which tab is active. So, your setup must not be using the Navigation Subform but probably something else. If so, as June7 said, it's probably better if we could take a look.

 

[tihmir]

Well, if you're using a true navigation form, I am not sure there is a link fields properties because the subform gets loaded dynamically. I'll have to check it when I get in front of a computer.

Еxactly! I am using a true navigation form. I think it will be able with reference a sub-subform in a navigation form.

I never use Navigation Form.

May I ask why you are never Navigation Form? and how to create form with tabs for subforms?

 

[theDBguy]

Еxactly! I am using a true navigation form. I think it will be able with reference a sub-subform in a navigation form.

Hi. When I select the Navigation Subform, this is all I see in the Properties window. So, if you're seeing the Link Fields properties, then you're not in a Navigation Subform.

Since you mentioned "sub -subform," then you're probably talking about a form with a subform inside your Navigation Subform, which would have these properties, and you should be able to enter field names in those properties then.

 

[June7]

I don't use because:

1. I find them trickier to reference in code - there are many threads on this topic

2. only one Navigation SourceObject is available at a time, referencing subform from another subform not possible

I use Tab control.

 

[tihmir]

I don't use because:

1. I find them trickier to reference in code - there are many threads on this topic

2. only one Navigation SourceObject is available at a time, referencing subform from another subform not possible

I use Tab control.

Уоu're right. I'll try through the Tab controls