Hi dlazenby,

If your popup form and main form are both bound to the same data source (ie:
same table), then simply updating the information on your popup form and
saving it should cause the main form to be updated.  To force a refresh, you
could call forms!MAINFORMNAME.refresh as your popup closes.

Hope this helps.

Damian.

I have almost the same situation as you and here is how I made it work:

Add a button to your first Form to open the popup frm.

example:

******************
'this comes from the OpenForm Button wizard

Private Sub cmdOpenPop_Click()
On Error GoTo Err_cmdOpenPop_Click

   Dim stDocName As String
   Dim stLinkCriteria As String

   stDocName = "frmCustomerPopup"

   stLinkCriteria = "[CustomerID]=" & Me![CustomerID]
   DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdOpenPop_Click:
   Exit Sub

Err_cmdOpenPop_Click:
   MsgBox"Error from Open Pop Form" 'Err.Description
   Resume Exit_cmdOpenPop_Click

End Sub
*******************

you need to have the CustomerID (your ID) on both Forms so they
connect to the same ID and Name.

on the (popup) form in the last field, in which you have to type in new
data,
before you close the form, do:

Properties, Event, AfterUpdate, Codebuilder,
then just copy the DoCmd code into the AfterUpdate.

Private Sub Form_AfterUpdate()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
End Sub

now, when you type in data in that last field and then press enter, the data
in
the popup form and in the first form is updated.
but you have to press Enter so the cursor will go to the next part which
then might
be the Close button.

(no refresh or requery needed. if you do a requery, the data in your first
form will
go to the first record and you don't want that).

I have 4 Checkboxes in the first form which I update (in AfterUpdate) with
this line:
  Application.RunCommand acCmdSaveRecord
this updates the data for my second form. you can also add this line to the
other 2 lines.
you can also try just this line instead the other two. whichever works, as
long it works.

hope that helps some.