Requery Form Value After Moving Focus Back From Form2?

I have Form1 based on Table1 with unique records per employee/position. Form1 is used to updated position dates/active status/add new position info for an employee. I have Form2 based on Table2 which has unique record per employee. On Form1, I have a combo box to select which employee's records to view in the detail section. If I select a record from the combo box, the detail displays any existing records from Table1 for that employee. If I need to add a new employee, a command button opens Form2 where new employee is added to Table2, and a new record is also inserted into Table1 with the employee name and ID. When I close Form2 and return focus to Form1, my combo box is refreshed to display the employee just added, however I can't get the detail to show the new, partial record from Table1 for the new employee. Form2 is a stand-alone (not a subform on Form1).I've tried hooking Requery to OnGotFocus, but that either doesn't work or isn't activated by returning focus via code. I've tried adding a text box to the detail that contains the unique EmployeeNum and setting the control source of the text box to cboEE.Column(1) (which is the EmployeeNum bound column). Am back to trying to do stuff in code after long absence and
now feel lost in all the variations I've tried.