How to check for Open Form with vba

[John Michael]

How do you check for an open form with vba.
I'm trying to requery a subform with the below state ment and it only works
if the form is open.
Forms![Open Transactions]!ctrlOpenTransactionsSubform.Requery

Thanks
John Michael

 

[Allen Browne]

Try:
If CurrentProject.AllForms("Open Transactions").IsLoaded Then

If you are using A97 or earlier, you can use SysCmd(). Open the Northwind
sample database, and grab the IsLoaded() function from the utility module.