asked on 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! =)
Microsoft Access
Last Comment
John Tsioumpris
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is such an outstanding suggestion, that I could not wait until Monday to test it out. It worked beautifully! MUCH, MUCH appreciation and respect for you!!!
Glad i you liked it