Either of the previous methods will cause the main form's recordset to include the new record. However, it seems to me you also want the main form to position to the new record. That takes more work, though it's easier in Access 2000 than Access 97. Which are you using?
One other question--why are you using a separate form to add a record? When you say you want to make the main form show the new record, it makes me think that both forms have the same Record Source property. In that case, the main form is perfectly able to accept the new record by itself. If you're doing this because you need to protect some controls from editing, but need them available when adding a record, you can use the Form_Current event to set their Locked and/or Enabled properties. You can tell that the user is adding a record by testing the form's NewRecord property. Rick Sprague