Filter with three conditionals ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KelHemp
    New Member
    • Oct 2006
    • 16

    Filter with three conditionals ?

    I have a Form, Products1, based off Table1.

    I want to be able to search by using a combo box for records that have values in the Sec, Twp, and Rang fields.

    What I am using currently uses the SortBy and FindRecord commands, but the problem I run into is that it doesn't limit the records returned like a filter does, and I want to be able to tell, of thousands of records, how many are in, say... Sec 3 Twp 24 Rang 30.

    Not looking to do a count of any sort, just want to be able to limit the records returned to those exactly matching. I tried using a filter, but I don't know how to create the nested filter I think I'm needing. Advice?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Check out this tutorial posted by NeoPa

    Example Filtering on a Form

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32633

      #3
      Nice one Mary.
      Just wanted to register with the thread.
      (If you know a better way that works...)

      Comment

      Working...