closing forms if they are currently hidden

[jdashm]

When a certain form is opened I have VBA opening another form and hiding it.
When I close visible form I get an error message stating it can't find the hidden form. My VBA is trying to determine whether that hidden form is currently open and hidden but does not seem to work.
Here is a sample of that code:
================================================== ==================
Private Sub Form_Close()


' Closes the Delivery Board form if it is currently open and hidden when the Shipping Log form is closed

If Forms![frmDeliveryBoard].Visible = False Then
DoCmd.Close acForm, "frmDeliveryBoard"
Else
DoCmd.Close acForm, "frmShippingInfo"
End If


End Sub
================================================== ====================

Appreciate the help in getting this to work. Thanks.

[ssanfu]

Maybe try the IsLoaded property.

'================================================== ==================
Private Sub Form_Close()
' Closes the Delivery Board form if it is currently open and hidden when the Shipping Log form is closed

If CurrentProject.AllForms("frmDeliveryBoard").IsLoaded = True Then
   DoCmd.Close acForm, "frmDeliveryBoard"
Else
   DoCmd.Close acForm, "frmShippingInfo"
End If


End Sub
'================================================== ====================

[jdashm]

That seemed to do it. Many Thanks!!