Declare a public boolean variable and set it to false in your code before you
show the form.

Include a line setting the value of this variable to True when OK is clicked

back in the code that called the form, include a line to close the sheet if
the boolean variable is false.

"Doug" wrote:

I have a command button on a form that checks a password, if OK, it opens a
sheet. If I use the X on the top corner to close the form it opens the sheet
without checking the password. How do I close the sheet if the form is
exited. Thanks for the help.