Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    144

    Red face Unanswered: popup form on certain records

    Hi All

    I have a form with one label field which I would like to have it popup on certain records as i browse through my main form?

    So i said to myself ok lets make a checkbox field (not visible) and add a code to the on current event of the form telling the form if check box is checked then no popups or else pop the form. But i think it is not working since i already have code on the on current event of the form which is for a button to become visible as i browse through records with another check box checked.

    Private Sub Form_Current()

    If DMRForm = True Then (Check box)
    If CustReq = True Then (New check box i just added)

    OpenVisaForm.Visible = True ( Button that becomes visible as i browse)
    Else
    OpenVisaForm.Visible = False
    End If
    'DoCmd.OpenForm "frmRequirement", acNormal (This is the form i like to open when CustReq checkbox is checked)

    'End If
    End Sub

    one more quick question:
    Should I use memo field instead of label since i want the popup form to have different data for each popup form?? this memo field will have 4 to 5 lines of instructions which will vary for each record some records may have it and some won't.

    Any help would be greatly appriciated.

    Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Should I use memo field instead of label since i want the popup form to have different data for each popup form??
    Yes.

    Code:
    Private Sub Form_Current()
       If DMRForm = True Then  '(Check box)
          OpenVisaForm.Visible = True '( Button that becomes visible as i browse)
       Else
          OpenVisaForm.Visible = False
       End If
    
       If CustReq = True Then (New check box i just added)
          'DoCmd.OpenForm "frmRequirement", acNormal (This is the form i like to open when CustReq checkbox is checked)
       End If
    End Sub
    Should be nothing too wrong with this.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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