Hi i am trying to explain as simply as possible. I have a combobox on my main form which when I select (a company) from it , it then autofills the relevent fields (employees) in my subform. My subform is datasheet view and data entry = yes. My subform then shows all employees of that particular company. I have set the subform to data entry = yes so that I can add a new employee. However, the new record line doesnt "inherit" the Company name and I have to select it again. What am I doing wrong? Thanks