473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Linking Subforms

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!
Apr 7 '07 #1
13 1474
dk4300
68
This is what I refer to for that type of thing:

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

Hope it helps.
Apr 7 '07 #2
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?
Apr 7 '07 #3
Have you tried Relationships?
Yes we've tried that, could there be some other way that we don't know about?
Apr 8 '07 #4
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!
Apr 8 '07 #5
nico5038
3,080 Expert 2GB
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)
Apr 8 '07 #6
Have you tried Relationships?
Does it have anything to do with VBA, or codes?
Apr 8 '07 #7
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?
Apr 8 '07 #8
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.
Apr 8 '07 #9
nico5038
3,080 Expert 2GB
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)
Apr 8 '07 #10
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?
Apr 9 '07 #11
Sort of. So then how do you link those two together?
Hey, I get it now! Thank you!! :))
Apr 9 '07 #12
nico5038
3,080 Expert 2GB
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)
Apr 9 '07 #13
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!
Apr 10 '07 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: dskillingstad | last post by:
I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...
5
by: kkrizl | last post by:
I have a form that shows burglar alarm permits. I have a subform that shows the alarms that have occurred at the location of the permit (linked by permit number). There is a different fine schedule...
4
by: Oliver Gabriel | last post by:
Hi, i have a form linked to a table. Because it is a very large form, i placed a tab control in it with sub-forms, that correspond to the same table. If i link them with the primary key...
2
by: Mike Boozer | last post by:
I have two subforms on my main form. I want the records on subform B to correspond with the records on subform A which they do. However, I want the records on subform A to let me know if there is a...
1
by: santociabattari | last post by:
Hi Folks, I have 3 forms I want to link, so that when I advance 1 record in one form it will update the other two with the same record in the first form. I have tried using the form wizard (I...
1
by: ppwlee | last post by:
Hi, I have created a main form with 2 subforms, Both subforms are in datasheet view. I want to be able to pick a record from subform1 and the corresponding linked record (created by a...
7
by: ApexData | last post by:
I am using the following code in my TabControl to manage subform loads. The code assigns the subForms SourceObject. - Do I also need code to DeAssign the SourceObject when leaving the Tab, I'm...
3
by: Robert McEuen | last post by:
Using A2K3, Windows XP I'm handling a many-to-many relationship with a linking table structure as follows (irrelevant fields omitted): tblIssue PK_IssueID (autonumber, primary key) IssueName...
2
by: darnel | last post by:
I have 4 hierarchical tables and want to display it all together as a form and 3 subforms, when subform displays (and allow to add/edit) only relevant items from each superior subform. Tables are:...
3
by: 6afraidbecause789 | last post by:
Think school - students - discipline interventions - misbehaviors - staff for this one....On a mainform frmStudentInterventions, I have linked a subform (sfrmMisbehaviors) with another subform...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.