Secondly, this second subform that you have added is unnecessary and I feel there is a misunderstanding of the way this form works. The main form is tied to TblAssessment which contains all three fields, t/d/o, so they should just be another three fields on the form, not treated any differently to any of the others. Design the form according to what the user can enter/modify - e.g. first they enter TeamID, a combobox, then requery DistrictID combobox, if they can enter it, otherwise display it from TeamID. Same with org.