SubForms and Tabs

[SVNTY7]

Good Morning All,
I have tried to search previous posts, but can not find one that addresses my problem.
I have a form with Student information, I then have four subforms(Request, Loans, Grants, Awards) each one is on a seperate tab. All the subforms are linking using a student ID. What I would like to be able to do in enter a term on the first subform, then when I go to the next subform, have the term "carry over" to the next subform and so on. Now I have to manually enter the term in each of the subforms.

Can anybody help?

Thanks,
77

 

[Fizzio]

Are you looking up the 'term' from a lookup table and just linking via a FK (termID) - this is the correct structure.
You may be better served using Nested Subforms. MainForm selects the Student, SubformLevel1 select the Term and Subform(s) Level2 holds the Request, Loans Grants and Awards.
Link Master/Child Main-Level1 by Student ID and Level1-2 by StudentID and TermID.

Failing that, if you want to carry over the term, on the On-Enter of the subform(s) copy the term from the previous form. This means that you will have to make sure that the same form is completed first (It maybe worth disabling the other forms until the request form is completed) then on the Before_Insert preopert of the form, (ie creating a new record),

Me.NameofTermControl = Forms!MainForm!RequestSubform.Form!NameOfTermControl.

HTH