exit form and close sheet

[Doug]

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.

 

[Doug]

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]

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]

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