Robert,

Before the last line of the form has been executed after I clicked the close button, I did a SELECT xxx, since it did not error, it was open at that time.

Walter,

>Did you try the following
>
>If Used("xxx")
> Use In xxx
>Endif