how do you check...

[rodchar]

hey all,

how do you check if a form is open or not in vba?

thanks,
rodchar

 

[Allen Browne]

In Access 2000 and later, you can test if Form1 is loaded like this:
CurrentProject.AllForms("Form1").IsLoaded

In older versions, use SysCmd with acSysCmdGetObjectState. The Northwind
sample database has a wrapper function for this called IsLoaded().

You could also tes if Forms("Form1") produces an error.

 

[rodchar]

thank you.

In Access 2000 and later, you can test if Form1 is loaded like this:
CurrentProject.AllForms("Form1").IsLoaded

In older versions, use SysCmd with acSysCmdGetObjectState. The Northwind
sample database has a wrapper function for this called IsLoaded().

You could also tes if Forms("Form1") produces an error.

 

[Bobpj]

As always Allen, a quick sharp and accurate answer.

It helped me a great deal.

Cheers