File available here: http://www.accessallinone.com/access-2010-no-vba-downloads/ Please select: DbVideo21 To reference a subform: Access treats sub forms as controls on the parent form so to reference a sub form control you need the code Forms!FormName!SubFormName.Form!SubFormControlName. e.g. Parent Form: frmMain Sub Form: frmStudents Control: StudentID = Forms![frmMain]![frmStudents].Form![StudentID] Topics covered: Opening a data entry form Temporary Variables Form OnLoad Event