Linking Subforms

[Boogabooga]

I'm new at access (studying it in school), we're making fake report cards for the actual students in this school and everyone in my class is stuck on one problem. The order the forms go in is form/subform/subsubform/subsubsubform, and we're trying to link the data from the subsubsubform to the subform. The question we have is how do you do that? (Our teacher is too arrogant to tell us himself so the fate of our grades rely in your hands). Please respond soon!!! Thank you!

[dk4300]

This is what I refer to for that type of thing:

http://www.mvps.org/access/forms/frm0031.htm

Hope it helps.

[cjbrx3115]

I'm new at access (studying it in school), we're making fake report cards for the actual students in this school and everyone in my class is stuck on one problem. The order the forms go in is form/subform/subsubform/subsubsubform, and we're trying to link the data from the subsubsubform to the subform. The question we have is how do you do that? (Our teacher is too arrogant to tell us himself so the fate of our grades rely in your hands). Please respond soon!!! Thank you!

Have you tried Relationships?

[Boogabooga]

Have you tried Relationships?

Yes we've tried that, could there be some other way that we don't know about?

[Boogabooga]

This is what I refer to for that type of thing:

http://www.mvps.org/access/forms/frm0031.htm

Hope it helps.

It didn't help as much as I wanted it to. I don't understand what it is. Can you please explain. Thank you!

[nico5038]

When you add a subform with the wizard, there will be a proposed linkfield.
By single-clicking a subform in designmode you can open the properties and under the datatab you'll se the fields used for the linking of the main and sub form.

Just make sure that each subform is linked with the proper field(s) to the mainform (or the subsub to the sub form, etc.) and it should work as expected.

Nic;o)

[Boogabooga]

Have you tried Relationships?

Does it have anything to do with VBA, or codes?

[Boogabooga]

When you add a subform with the wizard, there will be a proposed linkfield.
By single-clicking a subform in designmode you can open the properties and under the datatab you'll se the fields used for the linking of the main and sub form.

Just make sure that each subform is linked with the proper field(s) to the mainform (or the subsub to the sub form, etc.) and it should work as expected.

Nic;o)

Thanks for your reply. But, How do you link the subsubform to the main form?

[Boogabooga]

When you add a subform with the wizard, there will be a proposed linkfield.
By single-clicking a subform in designmode you can open the properties and under the datatab you'll se the fields used for the linking of the main and sub form.

Just make sure that each subform is linked with the proper field(s) to the mainform (or the subsub to the sub form, etc.) and it should work as expected.

Nic;o)

Thanks for your reply. But, How do you link the subsubform to the main form? For example, i have the field "subjects" in the subsubform and i want to link it to the "subjects" in the main form.

[nico5038]

Basically you don't link the field "subjects" in the subsubform to the "subjects" in the main form. In such a case the subsubform should be made a subform on the mainform.

Getting the idea ?

Nic;o)

[Boogabooga]

Basically you don't link the field "subjects" in the subsubform to the "subjects" in the main form. In such a case the subsubform should be made a subform on the mainform.

Getting the idea ?

Nic;o)

Sort of. So then how do you link those two together?

[Boogabooga]

Sort of. So then how do you link those two together?

Hey, I get it now! Thank you!! :))

[nico5038]

Guess you found out that the wizard will propose the needed fields and that with the single-click you can check/change the linkage fields.

Success !

Nic;o)

[Boogabooga]

Guess you found out that the wizard will propose the needed fields and that with the single-click you can check/change the linkage fields.

Success !

Nic;o)

Yup. Thanx!