Automatically updating fields in a SubForm from another SubForm

[hthg21]

I am having trouble figuring out the method to automatically update some fields in SubForm from 2 other SubForms.

I have attached 2 pics, the first GradeEntry1 shows what the tblTopic_Class_Grade form looks like after I manually enter everything into it. GradeEntry2 is what the form looks like when I fill out the Form starting at the top.

I'd like the tblTopics_Class_Grade form auto-populate the TrainingClassID (it currently does this), TopicClassID, StudentID, TrainingTopicID based off the entry from the above forms.

My end goal is that I need to have a grade for each student on each training topic for each class. Like:

Class1-Student1-Topic1-GradeX
Class1-Student1-Topic2-GradeX
Class1-Student2-Topic1-GradeX
Class1-Student2-Topic1-GradeX

Any and all ideas are appreciated!

 

[Galaxiom]

The common data should be completed in the main form. Then the LinkFields of new records in any of the subforms will be automatically populated.

 

[hthg21]

Galaxiom,

Thanks for the quick response, but it seems to me the logical progression would be to create in the following order:

Class
Students
Topics
Grade


Am I missing something, I do have a thick skull?:banghead:

 

[Galaxiom]

I am having trouble understanding the issue. Could you post your table structure? Either a copy of the database with sensitive data removed of an image of the relationships.

 

[hthg21]

I won't have a pic until tomorrow, but what is happening is that i get the linked data from the main form, but i want a couple pieces of the data from another subform.
I just dont want the users to have to enter the Student Name and Topic in twice.

 

[Dhamdard]

You need to have similar fields in sub to link them with main form. I usually design the main and then drag and drop the sub table into the main form in design view. Access automatically opens a menu asking for fields from the sub to link with the main. You can select as many fields from the sub to link with relevant fields in the main as you want.

 

[hthg21]

The problem is the fields i want aren't in the main form, they are in 2 other subforms.

I think either an Append query or some code grabbing the records i want and putting them in the third table is needed.