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?