find out if a from is open

[EEK]

OK, I admit it, I'm lost. I searched and found the code to find out if a form is open, but I don't know how to use it. How do I "pass the from name to the function"? I keep getting mismatch errors
Please help!

 

[selenau837]

OK, I admit it, I'm lost. I searched and found the code to find out if a form is open, but I don't know how to use it. How do I "pass the from name to the function"? I keep getting mismatch errors
Please help!

it may help to see what code you are using.

Also when you pass the form name are you including it in quotes. I believe in order to pass it as a sting you have to include it in quotes. Try that also.

 

[EEK]

thanks I got it to work.

 

[selenau837]

thanks I got it to work.

welcome...what did you do to fix it.

 

[EEK]

I put the formname in quotes in the Close event of my form per your suggestion, that worked. Thanks again.

 

[selenau837]

I put the formname in quotes in the Close event of my form per your suggestion, that worked. Thanks again.

Glad, it worked.

Thanks for posting back what you did to fix it. It helps others out in the future.