Check if a form is open.

[bodylojohn]

Hello everyone,

I have a question:

I have a form in wich I can add and edit employees.
I can open this "employee" form in 2 ways:
1. From another form
2. From the mainmenu

When I close the "employee" form I want to check if the otherform (1.) is open. If it is open I want to requery the other form. If it is closed I don't want to requery the other form.
How can I check if the other form is open?

I hope that you guys can help me and thanks in advance,
Johnny

 

[ansentry]

Do a search on IsLoaded Function.

You can import if from the Northwind sample database that comes with Access.

 

[bodylojohn]

Thanks

Thank you very much.

I got it working with the is loaded function...

 

[freakazeud]

re:

Hi,
just as an addition...in Acc2000 and higher you do NOT need the UDF IsLoaded function anymore...all it takes is:

If CurrentProject.AllForms("YourFormName").IsLoaded Then
...

HTH
Good luck

 

[ansentry]

How about that;

If CurrentProject.AllForms("YourFormName").IsLoaded Then

"You learn somthing new every day"

Thanks freakazeud

 

[freakazeud]

re:

Sure...no problemo