Filter unchecked box

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hutch
    New Member
    • Mar 2007
    • 74

    Filter unchecked box

    Here is the code i am using to filter completed check boxes

    OnClick
    Me.Filter = "Check Box"
    Me.FilterOn = True

    This filters any check box that has been checked off.

    How do i filter to look at what has not been checked?

    thanks in advance.
  • hyperpau
    Recognized Expert New Member
    • Jun 2007
    • 184

    #2
    Originally posted by Hutch
    Here is the code i am using to filter completed check boxes

    OnClick
    Me.Filter = "Check Box"
    Me.FilterOn = True

    This filters any check box that has been checked off.

    How do i filter to look at what has not been checked?

    thanks in advance.
    Me.Filter = "((Check Box='False'))"

    Comment

    • JConsulting
      Recognized Expert Contributor
      • Apr 2007
      • 603

      #3
      Originally posted by Hutch
      Here is the code i am using to filter completed check boxes

      OnClick
      Me.Filter = "Check Box"
      Me.FilterOn = True

      This filters any check box that has been checked off.

      How do i filter to look at what has not been checked?

      thanks in advance.
      How about something simple?

      Code:
      Me.Filter = "Check Box" = False
      Me.FilterOn = True

      Comment

      • Hutch
        New Member
        • Mar 2007
        • 74

        #4
        Awesime thanks guys!

        Comment

        • Hutch
          New Member
          • Mar 2007
          • 74

          #5
          None of these are working.

          Comment

          • Hutch
            New Member
            • Mar 2007
            • 74

            #6
            Me.Filter = "((Check Box=False))"

            Here is the correct one

            Comment

            • hyperpau
              Recognized Expert New Member
              • Jun 2007
              • 184

              #7
              Originally posted by Hutch
              Me.Filter = "((Check Box=False))"

              Here is the correct one
              glad you found out. :)

              thanks for posting the solution.

              Comment

              Working...