Really weird Paul. Here's some code from the main form that opens the "Settings" popup. It works exactly as would be expected. I've looked at the offending popup at least 20 times I can't for the life of me see what it is about its Opening that would cause the main form to suddenly minimize.
Code:
Private Sub imSettings_Click()
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
' Click on the settings "gear". Be prepared to update the display (Main Form) if user changes the
' setting that dictates the number of rows per column.
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
Dim intTemp As Integer
intTemp = DLookup("NumRows", "tblSettings", "SettingsID = 1")
DoCmd.OpenForm "frmSettings", acNormal, , , , acDialog
intBlkSz = DLookup("NumRows", "tblSettings", "SettingsID = 1")
If intTemp <> intBlkSz Then
bolReOpen = True
DoCmd.Close
End If
End Sub