Sub Form Link is Not Correct (1 Viewer)

access2010

Registered User.
Local time
Today, 01:15
Joined
Dec 26, 2009
Messages
1,021
Could I please have some help by advising us why our;

Sub Form = Symbol_Stock
does not match the Main Form\s = Symbol_Stock

Thank you for your assistance.
Crystal
 

Attachments

  • Sub_Folder_Not_Linking_On_Tab=21=083.mdb
    620 KB · Views: 226

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:15
Joined
May 21, 2018
Messages
8,527
Works for me
symbolstock.jpg
 

access2010

Registered User.
Local time
Today, 01:15
Joined
Dec 26, 2009
Messages
1,021
Thank you Majp, for your note
The two stock codes should be the same.

Nicole
1616615337247.png
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:15
Joined
May 21, 2018
Messages
8,527
Yes that is correct. Your subform was not linked to the main form correctly as I show in the image, where it has been corrected.
 

access2010

Registered User.
Local time
Today, 01:15
Joined
Dec 26, 2009
Messages
1,021
Thank you, Majp for your note.

We are using Access 2003 and I can not find the Linked Master Field in our form.

Could you please let me know where this field is?

Thank you.
Nicole
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:15
Joined
May 21, 2018
Messages
8,527
The subform control tht holds the subform
 

missinglinq

AWF VIP
Local time
Today, 04:15
Joined
Jun 20, 2003
Messages
6,423
With the Subform selected go to Properties - Data and you'll see Link Master Fields/Link Child Fields.

Linq ;0)>
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:15
Joined
May 21, 2018
Messages
8,527
Look at the image I posted and see the yellow highlight around the subform control, not the form inside the subform control
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 09:15
Joined
Sep 12, 2006
Messages
15,652
I thought you meant the main subform in the tab control, child 317. That's what @MajP indicated in yellow, I think.

Click the outer border of subform Child317. As it's in a tab it might be hard to get. Sometimes you get the subform, and other times you get the tab itself. That's what you want. The actual container control for the subform. Then right-click that and select properties. That's effectively the control on the main form that represents the subform.

The data tab shows the links, and they are blank. I presume that's the subform you mean, child 317. You need a master field from the container form, and a linked field for the subform. It might be multiple fields.

You can achieve the same thing in code, by making the query for the subform actively depend on a value in the parent form, or in a variabel somewhere, and then requerying the subform in the current event of the container form.

eg, you can't link two continuous forms directly, but you can do it code, and you can do it by managing a linking field common to both subforms in a container form holding both subforms.
 
Last edited:

Users who are viewing this thread

Top Bottom