exit form and close sheet
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.
|