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!
October 11, 2007 3:28 PM