Determine whether form is open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top