Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: checking to see which form is open then run code

    how can i check to see if a form is open... and if that form is not open check to see if next form is open then run code

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Look into the Application.Forms collection.
    oh yeah... documentation... I have heard of that.

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

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    still lost

    the name of the form i want to see if is open is pickupsheet

    Application.Forms ?????????????????

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Did you read about the application.forms collection yet?
    oh yeah... documentation... I have heard of that.

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

  5. #5
    Join Date
    Dec 2004
    Posts
    277
    no

    where can i find this?
    Last edited by DackJaniels; 01-13-05 at 14:58.

  6. #6
    Join Date
    Apr 2004
    Posts
    130
    You could try this:

    Function fncFormIsOpen(strFormName As String) As Integer
    Dim frmCurrent As Form
    For Each frmCurrent In Forms
    If frmCurrent.Name = strFormName Then
    fncFormIsOpen = True
    Exit Function
    End If
    Next frmCurrent
    End Function

    Winston

Posting Permissions

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