I have a columnar continuous form where I provide a button in header to open a single record tabular sub-form for data entry. The sub-form has an "OK" button to close the sub-form and return to the columna form. With the OK button "click" event on the sub-form I wish to not only close the sub-form but update (requery) the columnar form and return to the columnar form with the focus on the same record I was on when I started the whole process. I've tried all kinds of things and nothing seems to work. I found several ways to get the focus on the original record but I have to sacrifice the requery update and vice-versa. Can someone get me kick started. I'm in Access 2003 and trying to write the VBA for the "OK" button click event.