I'm a university case manager and newbie Access user. I created a database where a main form presents student data, and a subform (CaseNotesF) is where I enter case notes. The notes I enter in this subform automatically populates the linked student id number field (UID) in the CaseNotes table...