Access Form Controls: show only records that contain a specific value in a specific field...
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! =)
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! =)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad i you liked it
ASKER