I have created a hierarchical recordset with a main form and subform in a single form. The primary key of the main form is an autonumber field. A foreign key of long integer is in the subform. I'm relating the two tables via that primary key/foreign one to one relationship. The problem is I have to write some code to update the autonumber field in the main form with the new sequential autonumber (refresh, update, moveprevious, movenext). The subform is on a datagrid. The real problem is that when I enter data into the subform the data remains the same in the datagrid as I move about the recordset- this only happens when I enter new records. What's the best way of updating the autonumber in the main form and having that show in the subform? Thanks for your help.