I'm working in MS-Access 2010. I have a form based upon the table name "tblData." When the form loads, I'd like to only display records that have a "fldResults" text value of "Incomplete."
I'd also like to add a button on the form that can toggle back and forth between displaying all records from "tblData" and just records with "fldResults" text value of "Incomplete."
I'd love the minimize the amount of VBA that would be needed to accomplish this, but if a VBA sub routine is the best approach, I appreciate any recommendations. I won't be able to test any replies until Monday. Thanks in advance for any help! =)