if..then..else statement (silly question)

[Davros]

hi guys
sorry for the silly question but i'm banging my head at the moment

when i close a form i run a requery on another form. But if that other form is not open then i get an error massage.

Private Sub Form_Close()
Forms!memorial_search_results.Requery
End Sub

i have tried changing the above to an if..then..else statement but can't get it right

Private Sub Form_Close()
if Forms!memorial_search_results.open then
Forms!memorial_search_results.Requery
else
docmd.close
End Sub

Buth this does not work. what am i doing wrong??

 

[Access_guy49]

if Forms!memorial_search_results.open = true then ... Maybe??

 

[Davros]

thanks for the reply but the true statement does not work

any other ideas guys??

thanks

 

[Rich]

Look up the IsLoaded function

 

[Davros]

isloaded
exactley what i was looking for

cheers