I have a main form with a combobox. This combo box, Combo97, is unbound and gets its choices from lkpTerm. My subform, subfrmCCourses, is a list of courses and has a field called Term. I would like the subform to only show me the records where Term=Combo97. I have the Combo97 go to default value of current term so they may not have to update it.
This seems like a simple thing, but I can’t figure it out since you can’t set Combo97 as a Master Field for the Child Field of Term.
Jodi