Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Maine
    Posts
    49
    Provided Answers: 3

    Question Unanswered: Open form condition?

    Does anyone know how to check to see if a form is open? I want to get values for a report based on a value in text boxes in some forms. I want to check to see if FormA is open, if not, then get the value from FormB etc. I have thought of making a hidden text box with a default value on each form and checking for that condition. I'm sure that will work, but am looking for a more "built in" function. Thanks in advance.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have a look at the "AllForms" collection...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    As to say....

    Code:
    If CurrentProject.AllForms("myFormName").IsLoaded Then
       MsgBox "YES - LOADED"
    Else
       MsgBox "NO - NOT LOADED"
    End If
    Can you imagine what it might be for reports.....
    .
    Last edited by CyberLynx; 02-22-06 at 01:15.
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  4. #4
    Join Date
    Oct 2002
    Location
    Maine
    Posts
    49
    Provided Answers: 3
    Thanks for the replies guys! That's exactly what I was looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •