Determine whether form is open

S

Samantha

How can I check to see if another form is open? I basically want to pass data
only if the form to receive data is indeed opened.
thanks in advance. Samantha
 
V

Van T. Dinh

If you use A2000 or later:

CurrentProject.AllForms("TargetForm").IsLoaded

will return True if the Form is loaded.

If you use A97, you need to get the UDF from the sample database NorthWind.
This has also been posted in these newsgroups several time.

HTH
Van T. Dinh
MVP (Access)
 
Top