Hopefully I can explain this. I have a form that contains a sub-form. The form (table1) has an autonumber id and the sub-form (table2) is link to the form by a field linked to the autonumber id. It works fine the way it is if I input the data into the sub-form but I need to change it. I want to be able to take the info from table 3 and have it auto populate in the sub-form based on workorder id in table 1 which is also in table 3 but the info from table3 needs to be saved in table2.