Is Find file open?

I think the easiest method is to make the form which you use to open the dialog box modal, so that you cant close the datbase until you first close the form.

Have a Public variable in the form for example

Public dialogOpen as Boolean

In the form open event set this to False

In the code which opens the dialog you need to set the variable to
True just before you open and False just after you close.

In the form unload you have some code similar to this

if DialogOpen Then

    MsgBox "Close the dialog ...."
    Cancel = True

End If


There is maybe some code which you can use to automatically close dialog but I havent found it yet

Hi Terry!
How do I get it to work?
I have "Public dialogOpen as Bolean" as a declaration.
I have "Set dialogOpen = False" in the open event.
I get a compile error that says that it needs an Object.
What's wrong?

dont use set, just

dialgopen = False

Yes, it works. Thank You

In the event 2 dialogs are open when I close the form, it does'nt react when the one dialog is closed and the other is still open.

why do you allow more than one to be opened? You could disable the button which you use to open the dialog and then enable again at the same time you set dialogOpen. And actually if you did that you could use the status of the button instead of dialogOpen varaible.

That is correct. Thanks again.

your welcome, thank you too.