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.

I'm sorry, I'm a self taught rank amature at this. I don't understand your
suggestion. Can you give me some sample code please?
Thanks
Doug

"Sam Wilson" wrote:

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.

Your existing code must somewhere have an instruction to show the form,
something like

MyForm.show

What you need to do is put the lines

dim bCanc as boolean
bcanc = false

Once the password has been checked and is valid, put the line

bcanc = True

in your code. Then finally, after the line MyForm.Show you need to put

if bcanc = false then exit sub

Sam



"Doug" wrote:

I'm sorry, I'm a self taught rank amature at this. I don't understand your
suggestion. Can you give me some sample code please?
Thanks
Doug

"Sam Wilson" wrote:

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.

Great! Thanks for the extra info, it helps a lot.
Thanks
Doug

"Sam Wilson" wrote:

Your existing code must somewhere have an instruction to show the form,
something like

MyForm.show

What you need to do is put the lines

dim bCanc as boolean
bcanc = false

Once the password has been checked and is valid, put the line

bcanc = True

in your code. Then finally, after the line MyForm.Show you need to put

if bcanc = false then exit sub

Sam



"Doug" wrote:

I'm sorry, I'm a self taught rank amature at this. I don't understand your
suggestion. Can you give me some sample code please?
Thanks
Doug

"Sam Wilson" wrote:

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.