Synchronizing Two Subforms in MS Access

pts.
Tags:
Microsoft Access
In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for the year/term he graduated. Therefore, when I go to my Placement tab I want to be able to select from my Year and Term fields only the year/term combination that is recorded on my Alumni Class tab. So if Person A graduated in 2005 Fall on my Placement tab I want to be able to only select the year 2005 and the term Fall. Or if a person graduated twice (different degrees) first in 2004 Spring and then in 2006 Fall I only want to be able to select a Year/Term combination of 2004/Spring or 2006/Fall in my Placement tab, meaning that I can’t choose the year 2004 and then the term Fall because there is no 2004/Fall record in my Alumni Class tab, only 2004/Spring. I’ve tried creating a query on my ClassYear and ClassTerm fields in my Placement subform but it pulls all the year and term values available in the AlumniClass table, not the year/term combos for a selected individual. I’m not sure what to do. Any help that can be provided is greatly appreciated! If you need more info please let me know. Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following