I have a main form (Form1) to enter information into table1. One field is linked to table2. TO add information to table2 you can click on a macro button in form1 to open a new form (form2) to add information to table2. After you enter your information into form2 and click on the close button the linked information in Form1 is not updated. you can not see the information that you just added. I have added code into form2's close button to refresh form1. That works as long as form1 is open. Is there a way to add a if then else statment to determine if form1 is open. something like. if (form1 is open) then refresh form1 else close form. Any help will be GREAT!!

Thanks in advance

Have your code call a function named IsFormOpen - the call would
look something like this:

If IsFormOpen("form_name") = True Then ...
   your_code_goes_here
End If

Declare a public function named IsFormOpen() - here's the code:

Public Function IsFormOpen(ByVal strObjectName As String) As Boolean

    If SysCmd(acSysCmdGetObjectState, acForm, strObjectName) = acObjStateOpen Then
       If Forms(strObjectName).CurrentView = 1 Then
          IsFormOpen = True
       Else
          IsFormOpen = False
       End If
    End If

End Function